Prev: Conditional Formatting for entire row
Next: CUBEMEMBER
From: MaryD on 17 Feb 2010 13:13
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?
From: Duke Carey on 17 Feb 2010 15:23
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?
 | 
Pages: 1
Prev: Conditional Formatting for entire row
Next: CUBEMEMBER