hellow

I am trying to share an Excel sheet with colleagues. We are using the sharing funktionality within Excel and placing the Excel sheet on a common area on our file system.

When we use the sheet, the sheet offent Locks up - filtering is not working, scrolling is not working.

Trying to get arround this everybody is now accessing the sheet on a common server with remote desktop call to Excel an the sheet. But the problem is still the same - the sheet Locks up. Users are haning witin the sheet even when they have left the sheet.

Any ideas ? Is it possible to make this Work proberly ?

br Carsten

Hello,

you may not want to read this, but here we go:

The feature to share files in Excel is poorly implemented and will quickly lead to corrupt and un-manageable files. Shared files has never worked correctly in Excel. It is an after-thought that has never been completed. Therefore, it is riddled with bugs and aberrant behaviour.

Excel experts around the world agree that shared files should be avoided. 

They will become corrupt eventually. Some files very fast, others may take longer. But in the end shared files will present problems. They are impossible to troubleshoot, since the aberrant behaviour may not be reproducible on another machine. 

Some Excel funcitonality does not work at all in shared files.

The best advice is to avoid shared files in Excel. 

If you need simultaneous multi-user editing of your data set, then you may want to use a proper database instead. Access, SQL Server (Express is free), etc. 

At last-I have been fighting inconsistencies for days-just sure that I was goofing up.  I had a situation where  if two Access users exported/imported to the excel file at near the same time, they would often  get the same price result even though they had  exported different pricing factors.  Hard to believe that excel designers let this kind of thing happen.  Access has a very good "gating" feature that never lets this happen in a linked table file.