PDA

View Full Version : Name definitions lost after import



theSizz
07-03-2007, 01:29 PM
I'm using Access2007 and Excel2007.
After I export data from an Access query into an existing Excel spreadsheet, the name definitions that were previously defined in the spreadsheet are no longer valid.
Even though they appear in the Name Manager with the proper reference location the cells in the spreadsheet do not execute the formulas that make reference to the names. If I delete the name and enter it again all the formulas work as expected.
I was previously using Excel 2003 with Access 2000 and this was not a problem. I converted the Excel2003 spreadsheet to an Excel2007 and now I have the problem. If I export to the Excel2003 sheet everything works fine.

Anybody know if this is a bug or am I overlooking something?

Any help or suggestions would be appreciated.