Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Workbooks referenced by a deleted workbook

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 599
Default Workbooks referenced by a deleted workbook

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002-SP3 keeps trying to open deleted workbooks Tracker Excel Discussion (Misc queries) 1 December 12th 06 06:18 PM
Keeping data once referenced workbooks are closed. stuckupnorth Excel Discussion (Misc queries) 1 July 12th 06 10:37 AM
is it always necessary to open workbooks referenced in a formula levie Excel Discussion (Misc queries) 1 May 13th 05 12:14 AM
Workbook referenced by a deleted workbook Triggerfish Excel Programming 0 February 13th 04 06:09 PM
Referenced Workbooks scrabtree23[_2_] Excel Programming 0 November 12th 03 11:09 PM


All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"