Hi All,
I have a pivot table which is linked to a data model ( meaning I selected the option "add this data to the data model" ).
Now, as my source data is linked to a SAP business warehouse dashboard and each week more data is added (more lines) I would need to add more lines to the data model. With a normal pivot table i would just click " change data source" and add another X-lines to the pivot table.
It seems with the data model it's not that simple anymore and I can't seem to find the proper way to add lines to the pivot table without Excel crashing or creating a new pivot table on top of the existing and giving me the message that a pivot table can't overlap another. This is weird as i ask to change the data source for an existing one...
So: How can i go from e.g: "Dashboards!$P$1:$Q$5" to Dashboards!$P$1:$Q$1000 for the pivot table linked to the data model.
Anyone?
Thanks!
Kim
I have a pivot table which is linked to a data model ( meaning I selected the option "add this data to the data model" ).
Now, as my source data is linked to a SAP business warehouse dashboard and each week more data is added (more lines) I would need to add more lines to the data model. With a normal pivot table i would just click " change data source" and add another X-lines to the pivot table.
It seems with the data model it's not that simple anymore and I can't seem to find the proper way to add lines to the pivot table without Excel crashing or creating a new pivot table on top of the existing and giving me the message that a pivot table can't overlap another. This is weird as i ask to change the data source for an existing one...
So: How can i go from e.g: "Dashboards!$P$1:$Q$5" to Dashboards!$P$1:$Q$1000 for the pivot table linked to the data model.
Anyone?
Thanks!
Kim