Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Linked sheets

Status
Not open for further replies.

jeffwest1

MIS
Aug 29, 2007
50
NL
I have a number of spreadsheets that are linked to a series of data sheets. Every so often for no reason these sheets lose the links, although the sheets do not move, just get updated with data.

Despite clicking on 'Don't display the error and update links' on the edit links box, and also haviong 'Update links' ticked within options, this still happens.

Can anyone think of a way to get this to stay as set, or suggest alittle VBA code that will update the links everytime the sheet is opened.

The annoyance is that i have a VBA code that ruins and updates the sheets with new data when it is available, but this errors and stops when this error comes up.

Any help would be appreciated.

--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top