Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 -- Message posted from http://www.ExcelForum.com |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Triggerfish " wrote in message ... I believe I have deleted a workbook that may have had a link/reference to "Sheet1" in "ThisWorkbook". Everytime I start Excel I get the message "This workbook is referenced by another workbook and cannot be 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 the corresponding workbook in every file I have created over the last 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? Triggerfish --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002-SP3 keeps trying to open deleted workbooks | Excel Discussion (Misc queries) | |||
Keeping data once referenced workbooks are closed. | Excel Discussion (Misc queries) | |||
is it always necessary to open workbooks referenced in a formula | Excel Discussion (Misc queries) | |||
Workbook referenced by a deleted workbook | Excel Programming | |||
Referenced Workbooks | Excel Programming |