So I have several pivot tables that get their data from a atomsvc connection file (RSS). For some reason I keep having this issue where after a data refresh the complete table is blanked and the cells refering to it display #REF. As this is intermittent behavior I am unable to trace the root cause of this issue.
Just now I tried a refresh and one of the tables (connected to the same atomsvc file) did refresh but the ones after that all went blank. Does anyone have any troubleshooting tips on this? I find it hard to get any info on it.
Just now I tried a refresh and one of the tables (connected to the same atomsvc file) did refresh but the ones after that all went blank. Does anyone have any troubleshooting tips on this? I find it hard to get any info on it.