Finding a reference to anoter workbook

T

TorrO

Board Regular
Joined
Feb 13, 2003
Messages
118
Office Version
  1. 2013
Platform
  1. Windows
Hi

i cant find the help by serching, so... can somb please tell me how i can find the cell/or VBA code wich is pointing to another workbook?

Thanks
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Sort by date Sort by votes
One way to do this is by closing all of the other workbooks in Excel and search for ":\". Basically it is looking for all of the D:\Directories\Whatever. Someone else might have a better solution to this...

Hope this helps!
 
Upvote 0
If you go to the Tools/Options menu item, select the View tab. Under the Windows Options group click on the Formulas box so that it is marked.

This will show the formulas in your cells rather than the value. You can glance through the sheet and visually see any links.

That's the manual way of doing it anyway.
 
Upvote 0
:D
Thanks, is was so easy when i searched for ":\".

fterry: Ctrl+j gives the formulas i the cells, (norwegian language) one more time switch back to value!
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Solved
VBA - Find Replace on selected cells
Replies
3
Views
212
rsulliva
R
O
  • Question
How to automatically recalculate all workbooks in a office 365 spreadsheet each time its opened without using vba or macros.
Replies
5
Views
244
felixstraube
F
W
  • Question
Pulling the last records across open sheets
Replies
1
Views
239
WazMacNab
W
M
  • Question
offset Combobox.ListIndex
Replies
1
Views
116
RoryA
RoryA
B
  • Solved
VBA Copy adjacent AND non-adjacent named table columns
Replies
2
Views
200
Bleed_Air
B

Forum statistics

Threads
1,221,711
Messages
6,161,450
Members
451,707
Latest member
PedroMoss2268

Share this page

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
Back
Top