soloprogrammer
Programmer
I have a user that wants to export an Access report to an Excel spreadsheet.
Everything exports, except data in the Report Footer area. Only the first field of data in the Report Footer area exports. The other Report Footer fields are calculations --Dlookups and summary calculations based on the report. These fields are not displaying in the Excel Spreadsheet.
When I open the spreadsheet to see the results, there is an error message---Repairs to 'worksheetname.xls' "Renamed Invalid Sheet Name."
I close the error dialog box and can see most of the exported data except for the data in the Report Footer area as I mentioned earlier.
There are only 90 rows in the Excel spreadsheet.
Thanks in advance for your help!
Susan
Everything exports, except data in the Report Footer area. Only the first field of data in the Report Footer area exports. The other Report Footer fields are calculations --Dlookups and summary calculations based on the report. These fields are not displaying in the Excel Spreadsheet.
When I open the spreadsheet to see the results, there is an error message---Repairs to 'worksheetname.xls' "Renamed Invalid Sheet Name."
I close the error dialog box and can see most of the exported data except for the data in the Report Footer area as I mentioned earlier.
There are only 90 rows in the Excel spreadsheet.
Thanks in advance for your help!
Susan
