Hi everyone!
I’ve got a pivot table but the source info is from SQL server. This table (pivot cache) contains 450 000 lines.
As source db is no more available, I need to export source data from pivot table to MS Access db or to text file, to be able to make changes in it. So is there any way to do it without splitting pivot table to parts of 65K lines?
(Excel 2003)
Thank you in advance!