S
strutter_uk
In Excel 2003, by default if one user had an excel document open, any
other users that opened it while it was in use would be prompted that
they could only access the file as Read Only.
Excel 2007 is now in use on a number of workstations, but not all, so
it is necessary to retain the 2003 xls format across the company until
all users have access to Excel 2007.
The issue is that now 1, 2, even 7 users can open the same xls file at
once and not be 'locked' out. When saving the document there are no
prompts at all to say that x amount of users currently have the file
open or that the document.
How can a file retain it's 2003 compatibility but use the same
behaviour whereby 1st user to open has write access, any other users
thereafter have read only?
Any advice would be greatfully appreciated.
Thanks.
other users that opened it while it was in use would be prompted that
they could only access the file as Read Only.
Excel 2007 is now in use on a number of workstations, but not all, so
it is necessary to retain the 2003 xls format across the company until
all users have access to Excel 2007.
The issue is that now 1, 2, even 7 users can open the same xls file at
once and not be 'locked' out. When saving the document there are no
prompts at all to say that x amount of users currently have the file
open or that the document.
How can a file retain it's 2003 compatibility but use the same
behaviour whereby 1st user to open has write access, any other users
thereafter have read only?
Any advice would be greatfully appreciated.
Thanks.