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? -- Mike Watkins "ukredskin" wrote: > 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? |