RedllowFenix
New Member
- Joined
- Oct 5, 2017
- Messages
- 18
Hi there!
I'm having issues with the message "#GETTING DATA" in cells (inside a Profit and Loss Statement) where there is a circular reference (intended), as seen in the image below (sorry but my Excel is in Spanish). The complex/large CUBEVALUE formulas in the Excel files are linked to a data model using Power Query and Power Pivot.
I've looked online for solutions, but with no success. According to what I've read, turning on automatic computation in the spreadsheet might be effective, but it isn't.
I discovered a fix by selecting the formulas showing the problem, cutting, and pasting. To make this process automatic, I wrote a macro but I rather not to use one.
Any thougths?
Thanks
I'm having issues with the message "#GETTING DATA" in cells (inside a Profit and Loss Statement) where there is a circular reference (intended), as seen in the image below (sorry but my Excel is in Spanish). The complex/large CUBEVALUE formulas in the Excel files are linked to a data model using Power Query and Power Pivot.
I've looked online for solutions, but with no success. According to what I've read, turning on automatic computation in the spreadsheet might be effective, but it isn't.
I discovered a fix by selecting the formulas showing the problem, cutting, and pasting. To make this process automatic, I wrote a macro but I rather not to use one.
Any thougths?
Thanks