Wondering if anyone can help with the error message, cant seem to find any reference to it in the site.
Cheers.
Date
Votes
4 comments
-
Jet Reports Historic Posts At what point does this error occur? When entering design mode, running the report, etc?
Whilst I have not seen this error in the past, I have seen similar ones caused by 'bad' formulas. By bad I mean overally complicated quote marks or nested formulas, not specificall problems with Jet commands.
If you are able to get into design mode, go through all your formulas and review each one (especially any functions that are built in Excel ones) and simplify any if possible.
Might also be worth checking if any 'protection' through Excel is enabled (and disable it).
cheers -
Jet Reports Historic Posts This message appears when I try and run the report. All the formulas work in design mode.
Once the report is completed, the formulas don't revert to values.
Hope this sheds some light. -
Jet Reports Historic Posts When in design mode, what value is in cell A1?
-
Jet Reports Historic Posts Hey pauldubaich,
Often this is caused by cells that contain text that in the process of running the report, Excel thinks it is a formula.
For example, I had a report with '=A/C in a cell. Excel will try to evaluate this cell by taking A divide by C and error, which in turn results in a "worksheet lock failed".
A better way to write the contents of the cell is ="=A/C" which would prevent Excel from trying to evaluate it.
Please sign in to leave a comment.