Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summary sheet
I am trying to reverse engineer an excel workbook pivot table. It's
weird. I can see the Pivot table and trying to find out how it was done. I have done alot of internet searching for 2-3 days. I can see the Source is going to a "Summary Sheet" but there is not one listed on the tabs. I tried to find hidden sheets.. NONE. Is it possible to have a Summary Sheet in Excel not listed as a normal sheet? How do I view it? Thanks for your help in advance.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summary sheet
On Jul 14, 5:04*pm, Ty wrote:
I am trying to reverse engineer an excel workbook pivot table. *It's weird. *I can see the Pivot table and trying to find out how it was done. *I have done alot of internet searching for 2-3 days. *I can see the Source is going to a "Summary Sheet" but there is not one listed on the tabs. *I tried to find hidden sheets.. NONE. Is it possible to have a Summary Sheet in Excel not listed as a normal sheet? How do I view it? Thanks for your help in advance.. Visual Basic: I tried this too.. There was no sheet named Summary. To cancel the xlSheetVeryHidden option for a hidden sheet: 1. Press Alt+F11 to open the VBE. 2. Under VBAProject in the left pane, double-click the sheet name you want to unhide. 3. Press F4 or click the Properties icon to open the sheet's Properties dialog box. 4. In the Visible dropdown list, select xlSheetVisible. 5. Press Alt+F4 to close the VBE. On the Format menu, point to Sheet, and then click Unhide. If sheets are hidden by a Microsoft Visual Basic for Applications program that assigns the property xlSheetVeryHidden, you cannot use the Unhide command to display the sheets. If you are using a workbook with Visual Basic macros and have problems with hidden sheets, contact the owner of the workbook for more information. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summary sheet
On Jul 14, 5:34*pm, Ty wrote:
On Jul 14, 5:04*pm, Ty wrote: I am trying to reverse engineer an excel workbook pivot table. *It's weird. *I can see the Pivot table and trying to find out how it was done. *I have done alot of internet searching for 2-3 days. *I can see the Source is going to a "Summary Sheet" but there is not one listed on the tabs. *I tried to find hidden sheets.. NONE. Is it possible to have a Summary Sheet in Excel not listed as a normal sheet? How do I view it? Thanks for your help in advance.. Visual Basic: I tried this too.. There was no sheet named Summary. To cancel the xlSheetVeryHidden option for a hidden sheet: 1. Press Alt+F11 to open the VBE. 2. Under VBAProject in the left pane, double-click the sheet name you want to unhide. 3. Press F4 or click the Properties icon to open the sheet's Properties dialog box. 4. In the Visible dropdown list, select xlSheetVisible. 5. Press Alt+F4 to close the VBE. On the Format menu, point to Sheet, and then click Unhide. If sheets are hidden by a Microsoft Visual Basic for Applications program that assigns the property xlSheetVeryHidden, you cannot use the Unhide command to display the sheets. If you are using a workbook with Visual Basic macros and have problems with hidden sheets, contact the owner of the workbook for more information. More information: Here is what I'm seeing. Report/[Daily Tracker_23 Oct 09.xls]Summary'! $B$3:$E$48. Question: Is this a sheet named SUMMARY? right? And the sheet that I can see with the information only has 5 rows and about 45 columns. The Source is showing the info above with the Summary sheet --what? 48 rows with 4 columns. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate % in summary sheet from cell A9 in multiple sheet | Excel Programming | |||
How to calculate % in summary sheet from cell A9 in multiple sheet | Excel Programming | |||
Copy two summary ranges to master summary sheet | Excel Programming | |||
Generate sheet names from list, assign data to summary sheet. | Excel Programming | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) |