Dearest Excel Magicians, Wizards and Gods
I have a report that was made some time ago (P&L report).
It grew to 60mb at this point, and with all the pivots, caluclations etc - well, it got very obese, slow and lazy.
I figured out, that I will move all the source data to MS Access database.
But as many times before, the pre-existing Pivot sources are not being easily redirected to external Access source.
And re-doing all pivots from scratch will take way to much time (although I'm still considering it as my Plan "Z").
I've found out, that by pressing Alt + D + P in Excel, You start a Wizard and move it, but unfortunately I fail to do so every time.
It just returns an empty pivot time after time.
Can You give me some hints how to do with (via Pivot Wizard) or other, handy way to deal with this issue?
Thank You in advance for Your time.
With kind regards,
Simon.
I have a report that was made some time ago (P&L report).
It grew to 60mb at this point, and with all the pivots, caluclations etc - well, it got very obese, slow and lazy.
I figured out, that I will move all the source data to MS Access database.
But as many times before, the pre-existing Pivot sources are not being easily redirected to external Access source.
And re-doing all pivots from scratch will take way to much time (although I'm still considering it as my Plan "Z").
I've found out, that by pressing Alt + D + P in Excel, You start a Wizard and move it, but unfortunately I fail to do so every time.
It just returns an empty pivot time after time.
Can You give me some hints how to do with (via Pivot Wizard) or other, handy way to deal with this issue?
Thank You in advance for Your time.
With kind regards,
Simon.
