why do print range erase in Excel when import data from access

  • Thread starter Thread starter MaryD
  • Start date Start date
M

MaryD

I have a workbook set up in Excel 2007 that serves as a template for data
dumps from Access 2007. In the Excel template, I have set all the print
titles and print ranges for the various worksheets that need to be printed.
These worksheets use vlookup formulas to grab the data from Access. When I
export my data in Access (via a macro with TransferSpreadsheet) to my Excel
workbook, it dumps my data on a new worksheet in my template. After
exporting from Access, all the print titles and print ranges for the
worksheets that were previously set are gone and I have to go to the Print
Titles and set them again. This did not happen in Excel 2003, but now is
happening consistently in Excel 2007. Any thoughts why this is happening?
 
With only a little testing I'm not seeing the same issue.

Wouldn't it be easier to use the Data ribbon to get external data from your
Access table, and then simply right click on the range in Excel to
periodically refresh the data? That has no affect on anything but the table
holding the data.
 
Back
Top