S
Sam H. Carson
Hi,
I recently installed Excel 2007 and have encountered a major problem that is
seriously affecting my work.
When I open a pivot-table form from Access it now opens automatically with
Excel 2007 as opposed to Excel 2003 (as before). This in itself wouldn't be
a problem except that when I update the pivot-table and save a copy I cannot
access the saved copy before I close the pivot-table. The saved copy then
won't let me open it because it has errors. It may be related to the warning
Excel 2007 gives when trying to save as xls instead of xlsx.
This problem is made worse by the fact that when I re-open the pivot-table
in Access it is no longer a pivot-table - atleast Access doesn't recognise it
as one because it cannot be refreshed. It looks like it would if I selected
all worksheets, selected all, paste special and paste values.
I would really appreciate some help or direction on this one.
Thanks.
I recently installed Excel 2007 and have encountered a major problem that is
seriously affecting my work.
When I open a pivot-table form from Access it now opens automatically with
Excel 2007 as opposed to Excel 2003 (as before). This in itself wouldn't be
a problem except that when I update the pivot-table and save a copy I cannot
access the saved copy before I close the pivot-table. The saved copy then
won't let me open it because it has errors. It may be related to the warning
Excel 2007 gives when trying to save as xls instead of xlsx.
This problem is made worse by the fact that when I re-open the pivot-table
in Access it is no longer a pivot-table - atleast Access doesn't recognise it
as one because it cannot be refreshed. It looks like it would if I selected
all worksheets, selected all, paste special and paste values.
I would really appreciate some help or direction on this one.
Thanks.