Workbooks referenced by a deleted workbook

T

Triggerfish

I believe I have deleted a workbook that may have had a link/referenc
to "Sheet1" in "ThisWorkbook". Everytime I start Excel I get th
message "This workbook is referenced by another workbook and cannot b
closed" and then "Sheet1" opens without the default "Book1"

I know this matter is trival, but the message irritates me.

I have tried a macro that search for links/references and open th
corresponding workbook in every file I have created over the las
month. Yet no links are found the "ThisWorkbook" or "Sheet1".

I also tried uninstalling and reinstall as a last restort.

Has anyone else run into this problem?
Does anyone have any ideas?

Triggerfis
 
D

Dick Kusleika

Triggerfish

It sounds like there's a problem with a workbook in your XLSTART directory.
Try removing all the workbooks from there and restarting Excel. If you
don't get the message, then add them back one at a time, restarting Excel in
between, to see which one is the problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top