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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Nick67Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RogerKMillerAuthor Commented:
Thank you!
0
Nick67Commented:
No Problem!
0
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.