有时候，您可能会删除该复选标记 在更新时保留单元格格式 项目在数据透视表选项中意外。 在这种情况下，如果您的数据透视表包含单元格格式，则刷新后格式将被删除。 这是非常烦人的数据透视表不能保留格式。 今天，我会谈谈一个处理这个任务的简单技巧。
- 重用任何东西： 将最常用或最复杂的公式，图表和其他任何内容添加到您的收藏夹中，并在将来快速重复使用它们。
- 超过20文本功能： 从文本字符串中提取数字; 提取或删除部分文本; 将数字和货币转换为英语单词...
- 合并工具：多个工作簿和表格合二为一; 合并多个单元格/行/列而不丢失数据; 合并重复行和总和...
- 拆分工具：根据价值将数据拆分为多个表格; 一个工作簿到多个Excel，PDF或CSV文件; 一列到多列......
- 粘贴跳过 隐藏/过滤行; 数和总和 按背景颜色; 创建邮件列表和 通过Cell的价值发送电子邮件...
- 超级过滤器： 创建高级过滤方案并应用于任何工作表; 排序 按周，日，频率等; 筛选 通过大胆，公式，评论......
- 超过300强大的功能; 适用于Office 2007-2019和365; 支持所有语言; 在公司轻松部署; 全功能60天免费试用。
2。 然后选择 数据透视表选项 从上下文菜单中，看截图：
3。 在 数据透视表选项 对话框，单击 布局和格式 选项卡，然后检查 在更新时保留单元格格式 项目下 格式 部分，看截图：
4。 然后点击 OK 关闭这个对话框，现在，当你格式化数据透视表并刷新它时，格式化不会再消失。
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 2 months agoIt does work for me when I uncheck the "Autofit column widths on update".
To post as a guest, your comment is unpublished.· 2 months agomentira da porra isso.. nunca funcionou corretamente isso
To post as a guest, your comment is unpublished.· 6 months agoThis does not work when I try to preserve cell text alignment. For example, I want the text to be left aligned in a particular column. Upon refresh, the format resets.
Note for anyone offering to debug (if any kind soul is brave enough) - I often have multiple fields in the column section.
To post as a guest, your comment is unpublished.· 7 months agoWorthless guide. The "preserve formatting on update" setting does literally nothing.
To post as a guest, your comment is unpublished.· 10 months agoOK - I just found a solution. Use conditional formatting of the column.
I selected all my date columns; RIBBON - Conditional Formatting. Condition is any date greater than 1/1/1900; Selected the date format I want to use; Tested changes to the pivot data, refreshed and the formatting was preserved.
To post as a guest, your comment is unpublished.· 10 months agoI've tried this several times and it does not work for me. What version are you using? I am using MS Office 2016. I've been trying to manage dates as short date format. Very frustrating to have to select date columns and reformat every time the data is refreshed so that the TIME doesn't display.
To post as a guest, your comment is unpublished.· 10 months agohow can do freeze conditional formatting in pivot table during refresh sheet because when i am refresh sheet all conditional reset
To post as a guest, your comment is unpublished.· 1 years agodoes not work for me either on multiple instances of excel
To post as a guest, your comment is unpublished.· 1 years ago"Sometimes, you may remove the check mark of the Preserve cell formatting on update ... Today, I will talk about an easy trick to deal with this task" - what, you mean like, re-checking the box? Not exactly earth-shattering news...
To post as a guest, your comment is unpublished.· 1 years agoI'm using Excel 2013 and Preserve Formatting isn't working. The spreadsheet I am using was originally generated in Excel 2007.
To post as a guest, your comment is unpublished.· 1 years agodoesnt work
To post as a guest, your comment is unpublished.· 2 years agoThank you this worked really well for me and saved alot of time!
To post as a guest, your comment is unpublished.· 2 years agoI'm using Office 365 and "Preserve cell formatting on update" does not work.