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.