What is _xlfn.CUBESET?

[Legacy 328066]

I have a fairly complex (for me!) Excel 2013 spreadsheet using Power Query and Power Pivot to pull information from various SharePoint Lists, CSV files and OData feeds from other Excel spreadsheets to provide Actual vs Budget on the Maintenance Costs of the houses we have. (We are a Charity working with local Churches to house the homeless).

I am getting a constant error message when I refresh the Budget vs Actuals Pivot Table "Reference is not valid". The Pivot Table seems to be updating correctly however.

Using the ASAP Utilities (which I was pointed to by a post on here I think) I am using the Information / Create a List of all Range Names in Workbook and am getting an error reported thus:

Name Refers to
_xlfn.CUBESET =#NAME?

All the other Named Ranges in the workbook seem to be fine.

I have no idea what _xlfn.CUBESET is and my Google-fu has failed me in finding out

Can anybody give me some pointers as to where I can look to find where this is and whether it is safe to delete. I am assuming it is because the PivotTable seems to refresh quite happily even with the error!

Thanks.

Ian Watkins

 

[Legacy 328066]

I did have, and they weren't being used, but I've deleted them and the error message still persists.

I've done some fairly major restructuring of this workbook (mainly to change sources from Excel OData which I have found slow even with Buffering the PQ query) to SharePoint Lists (the SP List is also easier to share with our distributed workforce), but this error pre-dates this work.

Much head-scratching has ensued......

 

[RoryA]

When does the error message actually pop up? Only when you refresh that pivot table?

 

[Legacy 328066]

Yes. And as I say the PT is refreshing accurately.

 

[RoryA]

Did you make any changes to the PQ data/queries after you had already set up the pivot table?

 

[Legacy 328066]

Several. It's been a continuing work in progress for several months. Most people would do half of the work in a database, but as we don't have one, I've had to make do.

Is there any way to work out what's actually causing the error?

 

[RoryA]

I assume this is a PowerPivot pivot table, not a regular one?

 

[Legacy 328066]

Yep, several PQ queries, feeding a PowerPivot table.

 

[RoryA]

Can you share the actual file?

 

[Legacy 328066]

Probably not. The data contains sensitive information. Also it does alot of dynamic reads from SharePoint lists and CSV files.

 

[RoryA]

I guessed as much. Can you delete and recreate the pivot table?