Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Feb 2004
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel shared workbook - views not being stored (Excel 2002)

    I have a shared Excel 2002 workbook with about 8 users sharing. Each user edits the workbook and saves a particular "view", ie., with certain columns being hidden.

    Sometimes when they re-open the wookbook their view is remembered - other times it is not.

    I can't figure out what's going on - has anyone come across a similar problem. I've checked MS Knowledge to see whether it's a known bug, but we have SP3 installed and it's not reported as a bug with this release.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel shared workbook - views not being stored (Excel 2002)

    I don't know a solution to your problem, but I would like to warn you against using shared workbooks. They seem to corrupt easily. If you really need multi-user capability, a database (such as Access) is more robust.

  3. #3
    Lounger
    Join Date
    Feb 2004
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel shared workbook - views not being stored (Excel 2002)

    Thanks for the advice Hans.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel shared workbook - views not being stored (Excel 2002)

    I would like to add to Hans' advice.

    Sharing workbooks between more than 1 <img src=/S/smile.gif border=0 alt=smile width=15 height=15> users is something I would strongly advise against.

    You are now reporting just views that are not being retained over saves. But I have heard far worse problems arise from sharing workbooks: data not saved, workbook becoming corrupt (as in unusable and data completely lost!), changes made by user A included, but changes from user B not, ....

    Your best bet is to port this entire thing to another system, such as Access. Excel in a multi-user environment is a dead-end street. (Or should I say a dead-end alley in a dangerous neighborhood?).

    The cost for having something custom made may seem high, but loosing the work (or worse, basing decisions on wrong data) may far outweigh that cost.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •