show detail

  1. P

    Denormalization of data

    Hello Gurus I have an excel file as an input with project data. The data shows how many departments have worked on the project. The raw data looks like this: Project name Project description Division Department Start date End date Cash accounting Companies that are not obliged to deliver...
  2. K

    VBA Protected Book with PivotTables -- Allow "Show Detail" feature and delete sheets

    Hello, I have a project requiring the use of PivotTables in a protected Workbook. I need to code a macro that will allow users to drill down into the PivotTable values, and then will automatically delete them once the book has been closed. I have found plenty of threads demonstrating how to do...

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