REF error in the data range definition

Error: You are receiving a #REF error on Sheet1 when normally it should be RawData as the range.

Resolution:

• Copy the report and remove the template
  
• Run it and the RawData definition will still be corrupt
  
• Remove one Excel formula (this one contained a datevalue)
  
• Run – no error!
  
• Re-addthe datevalue Excel formula and re-rerun. 
  
• Added a PT to the RawData and rerun.

• Related Articles

• Error: An error occurred during configuration of inquiry

  Symptom When defining a connection to an MYOB Advanced tenant, the user is presented with a message about one or more inquiries not being set up and asking if the user would like to create them: After clicking Yes, the user is presented in an error ...

• Create a PivotTable to analyze worksheet data

  Being able to quickly analyze data can help you make better business decisions. But sometimes it’s hard to know where to start, especially when you have a lot of data. PivotTables are a great way to summarize, analyze, explore, and present your data, ...

• Number 75: Path/File access error

  Problem When launching any module of Intelligence Reporting, you get a file/access path error When trying to run a report you get this error Resolution Check that you have full read/write access to the Metadata Repository Check that you have full ...

• Error 438 Object doesn't support this property or method

  Error Error number:[438] Description: [object doesn't support this property or method] Source:[BICore] " Symptoms When trying to run a report, you get an error message appear immediately Troubleshooting Confirm whether it is isolated to only one ...

• Data Source name not found and no default driver specified. SQLState=IM002

  Error "Data Source name not found and no default driver specified. SQLState=IM002" when trying to run any reports Resolution Go to the Connector Find the connection the report with the error is running off Ensure the report is on the correct ...