“The formula must start with an equals sign. Portion with error: #REF!”
Yes , file processed successfully after removing the 'Print_report', but what is the wrong with the 'Print_report' Name manager. (='P:\DATA\EXCEL\SAPUPLOD\ME-04-97.XLS'!Print_report)
Secondly, Infragistic Excel dll should have to handle this error gracefully and processed the file with out throwing any error.
Would you please raise a ticket to fix this?
Thanks!
Hello,
Thank you for the file. I was able to get around the error by removing from the' Formulas' tab => 'Name Manager' => delete 'Print_report'. So I guess that the error comes from that reference. Please check it out and let me know of the results.
I have unlock the attached Data File.
Hello GarthGrainger,
This means that you have a reference or formula which does not start with an equals (=) sign. I took some time to review your workbook, removed all references and formulas from 'GFE' sheet and it was still throwing this exception. I discover that there is an 'ADMIN' sheet which is protected by password. It also has references and formulas but I was not able to modify it in any way. Please try removing the formulas from the second sheet and let me know of the results.