jwtaylorii
New Member
- Joined
- Oct 23, 2008
- Messages
- 12
I have a spreadsheet "pc816 post_pre call_mod March 2009" with pivot reports created and saved in a shared folder on the network. The reports work fine on the local network but when the spreadsheet is emailed the data source changes so that the reports will not update. Is there a way to keep the data source from changing on this file. Below is the example of the correct data source and then what the data source is when opening the file that has been emailed.
thanks,
The data source is 'Data'!$B$3:$AG$8000
'\DOCUME~1\Goughs\LOCALS~1\Temp\Documents and Settings\dispatch\Local Settings\Temporary Internet Files\Content.IE5\WDIVK9IF\[pc816 post_pre call_mod 030809[1].xls]Data'!$B$3:$AG$8000
thanks,
The data source is 'Data'!$B$3:$AG$8000
'\DOCUME~1\Goughs\LOCALS~1\Temp\Documents and Settings\dispatch\Local Settings\Temporary Internet Files\Content.IE5\WDIVK9IF\[pc816 post_pre call_mod 030809[1].xls]Data'!$B$3:$AG$8000