I am not sure I am totally understanding what your problem is. You send out
data to salesmen and they return the data and then you take that data and
convert it to a pivot table and then you convert the pivot table to a
summarized table and then you send that back out to the salesmen? I think if
I understood exactly what all was going on, I could help you. But can you
more clearly explain what you are doing. Maybe explain why you're doing it
too because perhaps I (or someone else) could then suggest a different way to
accomplish the same thing.

"YMTEO" wrote:

Hello,

I am working on some tables for forecasting.

Currently, to send an input table out to the sales man, I have to convert a
pivot table (with data) to regular table with formulas.
I have to copy the pivot and paste special values and manually add back my
formulas, ex =SUM. So that the sales man can overwrite the existing amount in
the table and not effecting the original source data.

Is there a more efficent way of doing this?
Currently the pivot tables has many sub total, and you can imagine how many
times I need to insert the formular into the regular table.