I have created a pivot table linked to a cube using MS Front Page 2002. Myself and one colleage can add/drop fields and check/ uncheck data filters as normal. No-one else can, the options are all greyed out - the table is static. In a prev version of FP ages ago I created html...
I have created a pivot table with multiple tables. I wish to create and separate column for some calculation based on pivot table date. After researching I found that I can use calculated field option in Calculations tab. But the option gets greyed out when I use power pivot or multiple ta...
If my co-worker downloads "Analyze in excel" file, creates pivot-table in it, sends to me, I get that error and also "Show fields" option is greyed out behing right mouse button options. If I do the same and send file to him it works ok. Updating Excel didn't help. tg...
I am using latest office 365 microsoft excel. I have created a pivot table with multiple tables. I wish to create and separate column for some calculation based on pivot table date. After researching I found that I can use calculated field option in Calculations tab. But the option gets gr...
1. BEFORE running the Show Report Filter Pages, we need to disable the “Save source data with file” option on the Data tab of the Pivot Table Options menu. You can get to this menu by clicking Options in the same drop-down as the Show Report Filter Pages. It is the split button ...
Why are the sort and filter options greyed out? Sometimes Excel’s sorting and filtering options become grayed-out and unusable for no apparent reason. This article explains how to fix the problem.3 Responses Anonymous says: March 1, 2021 at 3:39 pm The information you posted was a ...
Can’t Open Pivot Table Source… Like a good Excel fan, I switched to Excel 2016 to try the new version.While working on a Dashboard for a client, with a lot of Pivot Tables and charts in it, at some point, after moving some pivot tables and charts into other sheets, within the ...
Topic 41: Pivot Table Styles Topic 42: Sort manually Topic 43: Use an External Data Source Topic 44: Clear and Delete Old Items Topic 45: Count VS Sum Topic 46: Automatically Refresh Topic 47: Frequency Distribution Topic 48: Slicer Connection Greyed Out BONUS: FREE EXCEL PIVOT TABLE WEBIN...
Why can't I add a slicer to my pivot table? ClickPivotTable Analyzeon the menu. Click Insert Slicer (it's not greyed out, and does bring up the dialog) Choose my field (it is a field that's included in the pivot table) Click OK. ...
"Change Data Source" feature disabled for Pivot Table on PowerPivot in Excel 2013 "PowerPivot is unable to load the Data Model" in Excel 2016 and Windows 10 A single calue for column cannot be determined All PowerPivot options are greyed out All rows show the same data value even if relatio...