Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
151
Views
Topic starter
Hi,
I have a workbook where the graphs references to named ranges changes when 2 or more people have the file open simultainously in SharePoint. The named ranges are dynamic ranges similar to this: =OFFSET(PivotBatch!$C$4;;;PivotBatch!$D$4). What happens is that the named range reference changes from =PivotBatch!Batch to =_{r1} where the number 1 is a different number for each range. Has anyone seen this problem before?
Posted : 14/01/2021 10:47 am
Hi Nikolai,
Never seen this before, unfortunately. However, I'm not an intensive SP user, hope others can help.
Posted : 15/01/2021 12:13 pm
