Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Read only message caused by camping out in file
In my office we have different departments that use one main worksheet that
everyone fills in their section's data. I continuously get the READ ONLY NOTIFY message because the file is being used by someone else or they are in the worksheet and have left their desk doing something else. I have to walk around the office and find out who is in the file and ask them to get out. Is there a way to display the username that is currently using the file when the read only message comes up? thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Read only message caused by camping out in file
When I try to open a workbook in two instances of excel, I get an error
message that reads: Book1.xls is locked for editing by 'Barb Reinhardt' ... Do you not get that? I'm in Excel 2003. Barb Reinhardt "Rhett C" wrote: In my office we have different departments that use one main worksheet that everyone fills in their section's data. I continuously get the READ ONLY NOTIFY message because the file is being used by someone else or they are in the worksheet and have left their desk doing something else. I have to walk around the office and find out who is in the file and ask them to get out. Is there a way to display the username that is currently using the file when the read only message comes up? thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Read only message caused by camping out in file
Usually it does pop up with a "person" is using the file. On the other hand
if many users are using this workbook at the same time have you considered using the "share workbook" feature. It can be set to allow users to edit the workbook at the same time. -- Carrie "Rhett C" wrote: In my office we have different departments that use one main worksheet that everyone fills in their section's data. I continuously get the READ ONLY NOTIFY message because the file is being used by someone else or they are in the worksheet and have left their desk doing something else. I have to walk around the office and find out who is in the file and ask them to get out. Is there a way to display the username that is currently using the file when the read only message comes up? thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Read only message caused by camping out in file
Mine says Book1.xls is locked for editing
by '(company name)' ... sounds like it might be an issue to take up with my IT guys? "Barb Reinhardt" wrote: When I try to open a workbook in two instances of excel, I get an error message that reads: Book1.xls is locked for editing by 'Barb Reinhardt' ... Do you not get that? I'm in Excel 2003. Barb Reinhardt "Rhett C" wrote: In my office we have different departments that use one main worksheet that everyone fills in their section's data. I continuously get the READ ONLY NOTIFY message because the file is being used by someone else or they are in the worksheet and have left their desk doing something else. I have to walk around the office and find out who is in the file and ask them to get out. Is there a way to display the username that is currently using the file when the read only message comes up? thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Read only message caused by camping out in file
Mine says Book1.xls is locked for editing
by '(company name)' ... I will read about the sharing workbook feature, thanks for your suggestion. "Sninkle" wrote: Usually it does pop up with a "person" is using the file. On the other hand if many users are using this workbook at the same time have you considered using the "share workbook" feature. It can be set to allow users to edit the workbook at the same time. -- Carrie "Rhett C" wrote: In my office we have different departments that use one main worksheet that everyone fills in their section's data. I continuously get the READ ONLY NOTIFY message because the file is being used by someone else or they are in the worksheet and have left their desk doing something else. I have to walk around the office and find out who is in the file and ask them to get out. Is there a way to display the username that is currently using the file when the read only message comes up? thanks! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Read only message caused by camping out in file
Or send out a message to each user asking if they would do this:
Tools|Options|General and change their username to something more meaningful. (It was a pain when I'd see: Valued Gateway Owner) Rhett C wrote: Mine says Book1.xls is locked for editing by '(company name)' ... sounds like it might be an issue to take up with my IT guys? "Barb Reinhardt" wrote: When I try to open a workbook in two instances of excel, I get an error message that reads: Book1.xls is locked for editing by 'Barb Reinhardt' ... Do you not get that? I'm in Excel 2003. Barb Reinhardt "Rhett C" wrote: In my office we have different departments that use one main worksheet that everyone fills in their section's data. I continuously get the READ ONLY NOTIFY message because the file is being used by someone else or they are in the worksheet and have left their desk doing something else. I have to walk around the office and find out who is in the file and ask them to get out. Is there a way to display the username that is currently using the file when the read only message comes up? thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error caused by *.xls file | Excel Discussion (Misc queries) | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
"Unable to read file"message in Word & Excel | Excel Discussion (Misc queries) | |||
I am receiving a "unable to read file" message. How do I open? | Excel Discussion (Misc queries) | |||
Trying to open Excel/Word files error message "Unable to read file | Excel Discussion (Misc queries) |