Quick questions,
Whenever I refresh a report it is changing my cell references
From:
=LARGE(Data!$V$5:$V$37,ROW(INDIRECT("1:"&ROWS(Data!$V$5:$V$37))))
To:
=LARGE(Data!$V$38:$V$70,ROW(INDIRECT("1:"&ROWS(Data!$V$38:$V$70))))
Is there something that I need to do to fix this?
Also,
When I refresh the report can I specify which sheet I want to show?
Thanks!
Date
Votes
1 comment
-
Jet Reports Historic Posts Without seeing the rest of your report, there is no way to tell why that range is changing. It probably has something to do with Jet replication, but there's no way to know without knowing exactly what is in the rest of the report.
As far as specifying which sheet you want to show, I'm not sure exactly what you mean. If you are replicating sheets using NL(Sheets) then obviously you could change the filters on the function. If you just want to hide some sheets based on an option value, you could do that with a conditional hide. If you mean that you want only certain sheets to be calculated by Jet, then that is not possible. What do you mean exactly?
Regards,
Hughes
Please sign in to leave a comment.