theonlyluaguy
New Member
- Joined
- Mar 30, 2021
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Hello Forum Members,
Our Company finances are displayed in excel sheet pivot table that is connected to a database.
As you can see in the image below, there are a number of coloumns that we can expand or collapse based on what we need to see.
I am trying to create a new sheet where I get data from a selected number of cells like number of units sold for a particular product type.
The problem is if I expand or collapse the table, the values in the new sheet change to #REF and will only display values when the table is expanded in the way when the copying was done.
Say if I am copying the no. of product sold that is in H19 when all the sub coloumns are expanded, I get that value in my new sheet, but when I collapse a coloumn, those values goes away.
Is there a way to fix this ?
Thank you
Is there a way I can fix this
Our Company finances are displayed in excel sheet pivot table that is connected to a database.
As you can see in the image below, there are a number of coloumns that we can expand or collapse based on what we need to see.
I am trying to create a new sheet where I get data from a selected number of cells like number of units sold for a particular product type.
The problem is if I expand or collapse the table, the values in the new sheet change to #REF and will only display values when the table is expanded in the way when the copying was done.
Say if I am copying the no. of product sold that is in H19 when all the sub coloumns are expanded, I get that value in my new sheet, but when I collapse a coloumn, those values goes away.
Is there a way to fix this ?
Thank you
Is there a way I can fix this