Unhide columns - does not work?

Camel123

Board Regular
Joined
Jun 5, 2018
Messages
186
Hi,

Created a Pivot Table and a Pivot Chart. I want to hide all the data details in that sheet and only display the chart and slicer, which works perfectly fine. The only problem is I can not unhide the columns again even though they are all marked and I click "unhide". I've been going with ctrl+z but that will not work after closing the workbook and reopening it. How do I come around this issue?
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Move the Chart and Slicer to another sheet then you could hide the worksheet that has the data on it and then you can unhide when you need to.
 
Upvote 0
Yes you should be able to do all on one sheet, but if your having unhide issues then consider what I have suggested. A good dashboard idea is interface with slicers and pivots keeping the source data away from users.

The only other option I can think of is to possible upload a copy of the workbook so I can take a look. If there is sensitive data then change that first.
 
Upvote 0

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,569
Latest member
Honeymonster123

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
Back
Top