We have found an issue with refreshing a file on opening when the file name contains a square bracket i.e. “[” and “]”. When the file has a bracketed file name AND it has a pivot table, it displays a “Reference is invalid” error.
I have attached a small project to demonstrate the issue. I have also attached two input files, one with a pivot table “input file for brackets file names issue.xlsx” and another without a pivot table “input file for brackets file names issue without a pivot table.xlsx”. Both generated files will be saved in the same directory as the input file.
When you run the project the following files are generated:
- “generatedFile[in brackets].xlsx”
- “generatedFile(in brackets).xlsx”
- “generatedFile without brackets”.xlsx"
Only the 2nd generated file shows the reference error.