John Condie
New Member
- Joined
- Nov 8, 2023
- Messages
- 1
- Office Version
- 2021
- Platform
- Windows
I am using the Offset function on a number of columns in a large data table to produce a dynamic chart which updates automatically weekly. Each column producing a different column in the chart.
They have all worked fine for some 40 updates but now only 2 out of the 9 functions work.
I have checked the formulas for corruption but all are fine.
An example of the offset criteria: =OFFSET(Dyn!$AH$3,,,COUNTIF(Dyn!$AH$3:$AH$100,">0"))
Any ideas why some of the functions have stopped updating?
They have all worked fine for some 40 updates but now only 2 out of the 9 functions work.
I have checked the formulas for corruption but all are fine.
An example of the offset criteria: =OFFSET(Dyn!$AH$3,,,COUNTIF(Dyn!$AH$3:$AH$100,">0"))
Any ideas why some of the functions have stopped updating?
