Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Access data into Excel 2007 | Excel Discussion (Misc queries) | |||
import access data into excel | Excel Discussion (Misc queries) | |||
import data from access to excel | Excel Worksheet Functions | |||
How do I import hyperlink data from Access into Excel? | Excel Discussion (Misc queries) | |||
How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) |