REF error in the data range definition

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 ...
    • 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 ...
    • 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, ...
    • Richtx32.ocx error

      Issue: Richtx32.ocx or one of its dependencies not correctly registered Resolution Copy the file from your local machine to C:\Windows\SYSWOW64\ This can also be downloaded from here: https://www.dropbox.com/s/9u2vwicqdtb3x61/richtx32.ocx?dl=0 Go to ...