B
benou
I have a spreadsheet containing links to an Access database.
For some reason, the edit/Links buttons is not enable.
And all the option under DATA/Import External Data/ are disable also. Even
if I select the pivot table based on the link.
How can I change the link. I made the mistake to rename the query I used in
Access to link to this pivot table, and now I have 2 pivot tables pointing to
the same query but using a different name, so I'm stuck. Is there anything
else I can do, other than deleting my pivot table and recreating it? (which
is not a good thing to do because I have powerpoint slides pointing to these
table also)
And more generaly, is there a way to link a pivot table to an Access query,
but not link it to the name, but to the query itself, i.e. if I rename the
query, the link will still be good.
thanks,
Benoit
For some reason, the edit/Links buttons is not enable.
And all the option under DATA/Import External Data/ are disable also. Even
if I select the pivot table based on the link.
How can I change the link. I made the mistake to rename the query I used in
Access to link to this pivot table, and now I have 2 pivot tables pointing to
the same query but using a different name, so I'm stuck. Is there anything
else I can do, other than deleting my pivot table and recreating it? (which
is not a good thing to do because I have powerpoint slides pointing to these
table also)
And more generaly, is there a way to link a pivot table to an Access query,
but not link it to the name, but to the query itself, i.e. if I rename the
query, the link will still be good.
thanks,
Benoit