Rfcolon428
New Member
- Joined
- Feb 1, 2019
- Messages
- 8
On my pivot table, I click 'change Data source' and click the table range that I need and click OK. I go back to the pivot click refresh, nothing happens, go back to the Change Data Source' and the old Data source is listed.
Range - 'Open PO Raw Data'!$A$1:$AB$26160 (old source)
range - 'Open PO Raw Data'!$A$1:$AB$28189 ( new source)
when I go back to the Data source the old one is still there after changing it. It reverts back. I don't know why it doesn't keep my changes.
I emailed my spreadsheet to my co-worker and she was able to do it. It didn't revert back.
I have Excel 32 -bit and I have an add-ins for a SAP product.
Range - 'Open PO Raw Data'!$A$1:$AB$26160 (old source)
range - 'Open PO Raw Data'!$A$1:$AB$28189 ( new source)
when I go back to the Data source the old one is still there after changing it. It reverts back. I don't know why it doesn't keep my changes.
I emailed my spreadsheet to my co-worker and she was able to do it. It didn't revert back.
I have Excel 32 -bit and I have an add-ins for a SAP product.
