Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel : Sharing Violation & "Comments" trouble.

Status
Not open for further replies.

doldol

MIS
Nov 25, 2001
214
SG
Hi.

I have a issue that
there is an Excel file on a network server which users access to read & write files. The Excel workbook is accessed from around 6 users from different places.

and their office & windows versions differ. For example, Windows XP / Windows 2000 / Office XP / Office 2000 => Mixed.

Now, the problems are because it is very frequently updated by users, Excel "Comments" is not in the right location. but it is located in a wrong place.

And also, When users who have read & write permissions try to save, it says Sharing Violation and so, can't save it.

Any ideas? or workaround?
thank you in advance.

Somehow I know the comments is corrected by copying the sheets in a new one. But to avoid it, any suggestions?

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top