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 could and I may have to do that, but it is complex with conditional formatting and other stuff. Painful.....

 

[RoryA]

It's probably worth a quick test in a copy of the workbook. Just recreate a basic version and see if it refreshes without error.

 

[Legacy 328066]

OK, thanks for your help.