Linkage problem

  • Thread starter Thread starter Novella
  • Start date Start date
N

Novella

I have one spreadsheet which is linked to many. All of a sudden one
spreadsheet will not link. when I try, it pops up with the place where all of
my files are kept or all the way back into "my documents". I have saved both
as the same Excel type.
This has never happened before.
Any ideas?
thanks
 
In Excel 2007, look here

Office Button -> Excel Options -> Advanced

Scroll down to GENERAL

Click on the WebOptions button

Click on the Files Tab and deselect UPDATE LINKS ON SAVE.

This will prevent this issue on your machine moving forward, but it won't
prevent it if other machines edit the workbook.

If you have code in the workbook, you can add something (that I can't
remember) to the workbook_Open code to make sure that it's turned off for all
users if the macros are enabled.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link To File That No Longer Exists 1
Excel Excel spreadsheets opening at top instead of bottom. 4
Excel Protection 2
Alt codes 4
Bogus link in spreadsheet 3
Cell linkage ... 2
Linking excel spreadsheets into Word 1
Save problem for linked excel spreadsheet 2

Back
Top