Workbook doesn't appear to be opened but if you try to reopen it, Excel 2003 says it's already open.

An employee "saved" a workbook but when you try to open it you are asked to Enable Macros and then if you want to Update the links but afterwards the workbook doesn't open.  You are presented with Book 1, with sheets 1, 2 & 3.  (The actual workbook is 4MB and has 30 sheets.)  If you try to open the workbook again, it says that it's already open.  Transferring the file to another computer doesn't change anything. 2sch040511.xls
RogerKMillerAsked:
Who is Participating?
 
Nick67Connect With a Mentor Commented:
Ok,

I opened it in Excel 2010.
The workbook was hidden.
I unhid it and broke all the links.
The links image and the file are uploaded
2sch040511.xls
links.jpg
0
 
RogerKMillerAuthor Commented:
Thank you!
0
 
Nick67Commented:
No Problem!
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
RogerKMillerAuthor Commented:
Nick67,
Can you tell me how this happened?
0
 
Nick67Commented:
If you click Window on the toolbar and then Hide, it will hide the whole workbook.
About the only time you would use that is if you have UserForms on the go.
Someone must have done that accidentally.
The links, who knows?
Sometimes sloppy copy and paste can do that.
You mean to copy the formula in the cell and inadvertently wind up creating a cell reference instead
0
 
RogerKMillerAuthor Commented:
Thanks.  Didn't know there was a "Hide" command there!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.