![]() |
Convert Pivot to Table w Formulas
In Excel2007, I want to convert a pivot table to regular table with
formulas. Currnetly I have to copy the pivot and paste special values and manually add back my formulas, ex =SUM. Is there a more efficent way of doing this?The reason I do this is that once I have my pivot data, I want to change some of the data but not from the data source. Thanks |
All times are GMT +1. The time now is 08:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com