We have pivot table reports that are automatically created by an interface
from another system. The pivot tables and the data are in seperate workbooks.
When the reports are e-mailed a message box pops up stating that the workbook
contains links that cannot be updated, if "continue" is selected, we get the
message that the source data could not be opened. However the pivot table
then opens successfully.
How can we avoid getting these promts when these reports are sent out by
e-mail - we do need the recipient to still be able to use the pivot function
to 'drill down' to the data.