Prev: Excel 2003 errors when opening Excel 2007 document.
Next: Status Bar - SUM function adding grouped cells
From: watkincm on 10 Jul 2008 10:31
I have encountered the same problem when saving Excel 2007 reports in .xls
(2003) format. In this case the option to refresh data is not available -
nor do any pivot controls (e.g. Pivot Wizard) function.
Most of my colleagues are still on Excel 2002 or 2003 - this is becoming a
real problem - is there something I am missing here?
> OK - solved it, the data needed refreshing!!
> "ukredskin" wrote:
> > I can create a pivot table, and everything works, but when I save the
> > workbook, close it, and then re-open it I get the above message for all of
> > the reports.
> > Can anybody help?