Summary sheet

T

Ty

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..
 
T

Ty

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.
 
T

Ty

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top