I loaded a PowerPivot workbook with data from SQL 2008 R2. After building some pivot tables, charts, etc. I noticed that I had misspelled a word that was being used inside a slicer. I changed the spelling in the database and did a manual refresh
of data into PowerPivot. The refresh said it worked fine, but the value did not change in the slicer. So anytime I tried to select the misspelled value in the slicer I got the following error:
Query (3,22) The level '&[Eigth Grade]' object was not found in the cube when the string, [DimGradeLevel].[GradeLevelDesc].[Eigth Grade], was parsed.
I finally had to remove the entire slicer from all worksheets/pivot tables, save and close the workbook, then reopen. Upon reopening, Excel gave me the message that it had to remove some unrecoverable content. I then added the slicer back to
the worksheet and it appears to have cleared it up.
<<spoke to soon>>...
The spelling in the slicer has been updated, but it is still unusable (same error). It looks like I'll have to rebuild everything..
View Complete Post