I have a table for each month of the year on separate tabs each one named (both table and sheet) corresponding to the respective month
The tables need to be on separate sheets for usability reasons.
I want to create a pivot table which takes all 12 tables as input on one single sheet and allow...
I have a question about how to deal with multiple many2many relationships in Powerpivot. Here is my scenario: I have a bunch of products, where each product is assigned to at least one but potentially more categories, so for example my first table is
Product
Category
P1
C1
P1
C2...
Every month I used to prepare a Pivot which consists data of different regions and my requirement is to restrict people to access others data if I'll send the same Pivot to every one.Please help me.....
How to show to sales people only individual reports based on a password to a workbook. The workbook contains a sheet with sales data for the company; by selecting a sales rep in a pivot table filter, it produces necessary reports. How to show to the sales manager all the reports, but to each...
Hi All,
I have been using excel2007 for few weeks now.
Today I came across something "unusual".
Before when creating a pivot table, I would get the following screenshot
I could see"Drop data items here" as in excel 2003
Now I get something like that
The funny thing is that with some...
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.