Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reports in Excel?
Hi, is it possible to generate reports in Excel similar to access? I have
pupil names in rows, dates in columns, always row A; and data in the sheet. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reports in Excel?
Excel has not reporting tools similar to those in Access. You must create
your own reports. "PG Oriel" wrote in message ... Hi, is it possible to generate reports in Excel similar to access? I have pupil names in rows, dates in columns, always row A; and data in the sheet. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reports in Excel?
I am using Access reports from tables linked to Excel sheets.
To create a backdrop for the report, I am using a form format, in another Excel file, linked to an unbound object frame overlayed over the Access report. The Access report has controls sourced to the Excel table. There are several issues with this method. If I keep the Excel file open. The Access report takes a long time to open. Sometimes hangs and sometimes either Excel or Access crashes. The back drop format that is an Excel file is in a multi sheet Excel file. The link that reads this sheet is set by the file name (source document) and the range name (source item). However Access uses the sheet that was current last as the source item and not the range name that is set using the source item property. Is there some way to get Access do it right. I am using MS Office 2003 and Windows XP. -- Sajit Abu Dhabi "Chip Pearson" wrote: Excel has not reporting tools similar to those in Access. You must create your own reports. "PG Oriel" wrote in message ... Hi, is it possible to generate reports in Excel similar to access? I have pupil names in rows, dates in columns, always row A; and data in the sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Reports | Excel Worksheet Functions | |||
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report | Setting up and Configuration of Excel | |||
reports from excel | Excel Discussion (Misc queries) | |||
Reports in Excel | Excel Discussion (Misc queries) | |||
How to run Reports in excel | Excel Programming |