Our company had 200 + excel reports that we automatically refresh the pivot
tables each day and email them out. When we do a server migration or copy
for a new program we go into each pivot table and add the new view from the
new database. I have successfully changed the command text to the new view
on the new database, but to save file size we usually try to link pivot
tables to one pivot table if the fields/view is the same. When I try to do
it on these on one of those I get an error. Does anyone have a solution for
this? Is there a better way to manage all these excel reports?
Help! Frustrated Buissness Intelligence analyst.
Bookmarks