How to avoid unintentional link updates?
Posted by shane on May 01, 2001 12:40 PM
I have a 'source' spreadsheet(s.s.) with pivot tables on it. I have several 'desitination' s.s.'s that link to the 'source' s.s. Each 'desination' s.s. has a macro that will change the pivot table variables on the 'source' s.s. for the requirements of that particular 'destination' sheet. The problem arises when the 'source' s.s. is not open, but I open multiple 'destination' s.s.'s. What happens is that all the open 'destination' sheets that should not be updating their numbers (since the 'source' sheet is not open and I did not choose to update auto. links) automatically update their numbers to match those of the last 'destination' sheet that was opened. Is there any way to prevent this???