Sustaining Information

**Hejl82** · 04-23-2009, 08:21 AM

I maintain a project spreadsheet for our engineering group to list all projects that are being worked on each month. This sheet basically is just a long list with an autofilter on each column to sift between which engineer has a project and which manager or location the project is for. Other than the list being very long and a lot of information being present, there really is not anything difficult about the sheet.

My question is that I notice little quirks from time to time, with things like my autofilter moving rows as well as my freeze cells moving rows. My first thought is that this is a shared workbook, and not all users are on the same version of Excel. Two of us are using 2003, and the other 8 are using 97. Has anyone else come across issues like this? Is it a possibility that there is too much information for the filters to sustain their spots?

Attached is the sheet for reference, input would be valued. Thank you.

**Mallycat** · 04-23-2009, 08:30 AM

I have also found issues with shared workbooks and filters and freezing panes. I am not sure if you would know if someone else is making changes or not vs a problem with Excel

**martindwilson** · 04-23-2009, 09:18 AM

shared workbooks are prone to go wonky!
always make sure that if you go to tools/share workbook
that there are only the names ONCE of anyone presently having it open.
problems seem to arise when you see names in there of people who have either not got it open or their or your name is in there twice or more..if that happens
best bet is to get all users who are presently sharing it to save a copy and close the shared workbook including you
then you reopen it
it should say you(exclusive)
if it doesnt, remove everyone elses name including duplicates of yours
save reopen and check again
then get each to put their data back in seperately from their saved copy