Excel crashes when trying to update a data source in a pivot table

**game00baka** · 11-02-2020, 06:30 AM

Hi everyone,
I am new here.
I've got exact same problem, tried the method, it works fine but all my calculated field in pivot table gone as well.
Anyone know how to "not crash and save the calculated field"
or maybe easier way to make back the calculated field

**FDibbins** · 11-03-2020, 12:45 AM

Originally Posted by game00baka

Hi everyone,
I am new here.
I've got exact same problem, tried the method, it works fine but all my calculated field in pivot table gone as well.
Anyone know how to "not crash and save the calculated field"
or maybe easier way to make back the calculated field

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread