Not referencing hidden cells


I am having a problem with my Jet reports losing references to cells that are hidden at runtime. They show the calculations fine while I am designing the report but once it is scheduled and sent I end up with loads of cells with #REF!.

If I leave the worksheet that contains the parameters/variables on visible the report runs fine but it looks messy when the report is exported with the options sheet visible.


Please sign in to leave a comment.