As I am finalizing my report, I have noticed that certain cells that are linked to the options page , when changed to report mode or refreshed, are changed to “=OPTIONS$D$5” instead of the number in that cell, which is usually a 3 digit number. It works fine when in design mode, but will error out and this pull no numbers that are linked via formula when in report.
Is there a solution for this problem?
Date
Votes
3 comments
-
Jet Reports Historic Posts This isn't behavior I've seen before. Are the cells that contain the references to the Options page formatted as text by any chance?
-
Jet Reports Historic Posts Yes, they are formatted as text. I have actually since gone in and made them general (while in design mode), but when I refresh, they revert back to text format and don't work.
Anyone have any ideas?
Thanks so much! -
Jet Reports Historic Posts Does it only happen with this one report? What happens if you delete the rows on the options sheet and then recreate those options? Can you attach the workbook to your post so we can look at it?
Regards,
Hughes
Please sign in to leave a comment.