If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
why do print range erase in Excel when import data from access
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? |
#2
|
|||
|
|||
why do print range erase in Excel when import data from access
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. "MaryD" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|