An Excel question

Marc

Marc

TPer Emeritus
Suspended / Banned
Messages
34,670
Edit My Images
Yes
I'm not sure it's possible but you never know.

I have a spreadsheet which other workbooks link to (using vlookups). I need to make a coupl of changes to it but I need to have the workbooks which link to it open so that I can be sure those vlookups aren't compromised. I know Edit Links will give me any workbooks that this sheet looks up to but was wondering if there was a way to do it the other way round. I hope that makes sense.

Using Excel 2007 BTW.

Thanks
 
You mean open a workbook and find out which other workbooks link to it?

Dont think so, but have wished for this in the past..
 
Rapscallion said:
You mean open a workbook and find out which other workbooks link to it?

Dont think so, but have wished for this in the past..
Click to expand...

That's what I thought tbh, just hoped someone might have a trick up their sleeves. Will probably just have to make the changes and then deal with any issues (and moans from other users) with other sheets as they come up.

Thanks for the reply.
 
Depending on how far spread across your drives the files could be that link to it we've done things in the past with macros. Essentially they open up every single Excel file and see where it links to, then reverse the list to see what's linked to a specific file.

You'd need some VBA skills though
 
We had some rather excitable techie guys do it for us.

Sorry but can't think of any other approach.
 
The best thing to do is to structure your referenced spreadsheets carefully such that they have in effect output cells in an output sheet.

If you are referencing random cells in other worksheets you are storing up trouble for future debugging.
 
will69 said:
The best thing to do is to structure your referenced spreadsheets carefully such that they have in effect output cells in an output sheet.

If you are referencing random cells in other worksheets you are storing up trouble for future debugging.
Click to expand...

It's just a table that's used for reference. The problem is that multiple users have files that link to it.

It's not a major deal if I'm honest, I was just hoping that there might be a way to avoid any8 issues if the source file was changed as a lot of the columns/data is now obsolete.
 
Do a windows search across all disk searching for exel.files containing [reference workbook that should do It
 
You must log in or register to reply here.
Back
Top