Ronson's Blog
  • Home
  • Shuttlecock Game Log
Sign in Subscribe

Excel

A collection of 2 posts
Excel

Excel - Document not saved.

Occasionally, you'll be working on an Excel document and when you try to save it, it says "Document not saved." [1] To get around this problem quickly, you can 1. Select all your worksheets (Click the first sheet + SHIFT + Click the last sheet) 2. Right click on one of the
Sep 15, 2016 1 min read
Excel

Filter out an Item from a Pivot Table using VBA with an OLAP Data Source

The following VBA code does not work as expected: PivotField.HiddenItemsList Property (Excel) [https://msdn.microsoft.com/en-us/library/office/ff195478.aspx] Sub UseHiddenItemsList() ActiveSheet.PivotTables(1).PivotFields(1).HiddenItemsList = _ Array("[Product].[All Products].[Food]", _ "[Product].[All Products].[Drink]") End Sub To properly use this you must use the CubeField
Jul 13, 2016
Page 1 of 1
Ronson's Blog © 2023
Powered by Ghost