Reduce file size of an Excel Workbook by removing links!

preview_player
Показать описание
Links to other Excel files can quickly drive up file size. To keep your model's file size down, remove external links and replace them with just the values. This can help reduce file size by more than 50% if you are using a lot of input data.

0:00 Pain point: File size exploded
0:11 Root cause: Links to other Workbooks
0:32 How to fix: Go with value copy
0:44 Working in a team: Add link, date last updated and your name

#excel #finance #exceltips
Рекомендации по теме
Комментарии
Автор

➡ Check out my free intro course on *financial modeling* on aheadyx.com

Aheadyx