PDA

View Full Version : Excel 97 problems



25-11-1999, 09:56 PM
I have recently upgraded to Office 97 SR2

I have to analyze and report on data which is held in an Access 97 database

To do this I expert the data to a series of excel files which I then consolidate into one workbook for analysis and distribution. The consolidation is done by linking the various spreadsheets in the normal way.

However since I have switched to Office 97, I have been having problem in that it appears that access is exporting the files as excel 95 files which excel 97 can?t open as a linked file

Does anyone have a way round this problem?


Thanks


Cameron