F
FARAZ QURESHI
I have tried a lot of times for finding a solution for devising a pivot table
based on multiple ranges of similar structure possessing multiple fields
(instead of only Rows and Columns), but seems that there is no other way but
to carryout a manual calculation and formatting a table of my own.
Can someone assist me in devising a special macro for only a single workbook
which has the feature of PIVOT TABLE's refresh feature.
In other words, I want all other workbooks to be automatically calculating
normally, instead of F9 (manual calculation for all) option, and only the
refresh data/table to be used in one book. Since the data is bulky it takes a
lot of time for the table to recalculate even upon a simple and petite change.
Thanx & regards!
based on multiple ranges of similar structure possessing multiple fields
(instead of only Rows and Columns), but seems that there is no other way but
to carryout a manual calculation and formatting a table of my own.
Can someone assist me in devising a special macro for only a single workbook
which has the feature of PIVOT TABLE's refresh feature.
In other words, I want all other workbooks to be automatically calculating
normally, instead of F9 (manual calculation for all) option, and only the
refresh data/table to be used in one book. Since the data is bulky it takes a
lot of time for the table to recalculate even upon a simple and petite change.
Thanx & regards!