Unknown link in worksheet

HollyN

Board Regular
Joined
Jun 9, 2004
Messages
59
I have a series of workbooks that all apparently have a link to another excel sheet called "Feb Weekly Scorecard" because each time I open them up, I get the 'update links' option and I say YES---but I have no idea where this "Feb" book is referenced in my current workbooks. I've tried to do the FIND option and type in FEB in every different way I can and nothing shows up---it's like it's hidden somewhere that i can't see.

Any suggestions on how I can find out where it is within my data files?
Thanks !
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi Holly

Try looking in your defined names (Insert>Names>Define) and checking if you have any names with links to this external workbook.

Best regards

Richard
 

HollyN

Board Regular
Joined
Jun 9, 2004
Messages
59
unknown links in workbook

Nope that's not it---I looked and only had one for printing.
 

HollyN

Board Regular
Joined
Jun 9, 2004
Messages
59
unknown link in worksheet

That worked! It was listed as the top link so I just changed it to actually select nothing-basically remove/delete it and now I reopened and it doesn't ask for it.
It's just strange that this came into play somehow out of nowhere.

Thanks everyone for your input.
 

Forum statistics

Threads
1,136,268
Messages
5,674,734
Members
419,523
Latest member
Urnovio

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top