I've written a report that has multiple tabs on it, and for some reason the balance sheet one keeps breaking. It's fine in design mode. If I switch to report, it updates correctly, but then when I go back to design mode, the functions disappear and the numbers are hard coded. It is only one tab in the workbook that keeps doing this. Anyone know why this might be happening?
Date
Votes
4 comments
-
Jet Reports Historic Posts It's possible that either that worksheet has been corrupted or there is something else going on with keywords.
Are you able to upload the report for review? -
Jet Reports Historic Posts I had an epiphany on the way home, and this post confirmed it. I had some strange things going on in cell A1. Thanks for the help!
-
Jet Reports Historic Posts I have similar situation too. Only one of the tab is working and for other tabs, all functions are disappeared and values are all hard coded. I have to re-entered the function in the design view in order to run the report with new data. What should I do?
Thanks -
Jet Reports Historic Posts I have similar situation too. Only one of the tab is working and for other tabs, all functions are disappeared and values are all hard coded. I have to re-entered the function in the design view in order to run the report with new data. What should I do?
Thanks
I think the sheet is corrupted. You should re-enter the functions.
Please sign in to leave a comment.