pivot tables hidden sheets

Joe C

Well-known Member
Joined
Oct 17, 2002
Messages
841
Hi,
I am creating an interactive report using the pivot tables.
The report presents a lot of data then uses pre made medians against the
averages and std in the pivot tables to color code any possibly flawed data before reducing the pivot tables to just averages.
After user will have abiltiy to drill down to data and mark a record d or u in the drill down. this will then take the data out of the analysis andinto a dump sheet, and the pivot tables are recalulated.
Because I want all the data eliminated to go to the dump sheet so next time I retrieve data from the system I can then eliminate proior dumps I want to keep the data sheet hidden. Does hidding data sheet cause pivot tables any problems?
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,102
Messages
5,768,102
Members
425,454
Latest member
khoro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top