Excel表格与普通数据 [英] Excel tables vs plain data

问题描述

我有一个很大的Excel文件，其中包含带有纯数据的多个数据表以及几个基于这些数据的仪表板，其中包含各种图形和kpi. 我希望使文件更小，更快地处理.我应该将未格式化的数据转换为表格还是不转换为表格.我真的找不到任何东西可以支持这一点.

I have a large Excel file consisting of multiple data sheets with plain data and a couple of dashboard sheets with various graphs and kpi's based on these data. I am looking to make the file smaller and faster to work with. Should I convert the unformatted data to tables or not. I can't really find anything to support this.

有人有什么主意吗?

推荐答案

表具有很多优点，但通常比纯数据要慢，(尽管最新版本的Excel 2016显着提高了表速度).

Tables have a lot of benefits but they are generally slower than plain data, (although the latest version of Excel 2016 has significant Table speed improvements).

这篇关于Excel表格与普通数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！