Search results for query: *

Filtering out individual PivotItems so that they are not visible is useful, but numerical data apparently cannot be grouped when there is any text (including the PivotItem "(blank)") within the PivotField. Is there any reasonably simple way to remove a PivotItem of my choice. There...

Geoff, Thank you for all your guidance. I finally decided to eliminate the "Array(...)" that the Connection was being set equal to and replaced it with the string of arguments. Maybe using the Array() would require some sort of change to a dynamic array for the proper character...

Yeah, that was a good diagnostic. I also had it output the CubeDimension string to a spreadsheet cell. There doesn't seem to be anything wrong with it in either diagnostic (although the watch that I added did not seem to show the entire string because there seems to be a limit to the character...

xlbo, Thanks, all those ideas made sense and after checking it out and still having trouble, I simply tried editing the format of the working code segment to see if it would still work. For some reason it does not work when I change the 3 lines of code that are a part of the CreateCube...

'The following code segment works With ActiveWorkbook.PivotCaches.Add(SourceType:=xlExternal) .Connection = Array( _ "OLEDB; Provider=MSOLAP; Initial Catalog=[OCWCube]; Data Source= " + Range("A1") + ";" _ , _ &quot...

Using a macro recorder in Excel, I generated code for creating a Pivot Table based on an external database (comma delimited text file) and an OLAP Cube based on the data. Attempting to automate this code to accept any input data source, file name, and field queries I have replaced some...