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

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?
 
D

Duke Carey

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Multiple Spreadsheet Print problem 1
split print area in excel - One Page Print 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to automatically set print area in Excel template? 5
Export Data from another source to use in an excel template 0
Why do charts disappear? 2
Excel won't print 2

Top