Forum Discussion
Julie Carson
Mar 26, 2018Copper Contributor
Hyperlinks - how much do they change the size of a file
Hi, I am new to the community but have been working with Excel for a long time. The one thing that I am not sure of is if I am using hyperlinks just how much they add to the size of the file. I hav...
Haytham Amairah
Mar 26, 2018Silver Contributor
Hi Julie,
Don't worry about it!
I've done a simple test and you may be surprised when you know its result!
I created a workbook and copied the link of this community ten thousand times (10,000) in the range A1:A10000 of the Sheet1, then I made a copy of this worksheet in a separate workbook and deleted the links from it!
Then I compared the difference in size between the two workbooks, which is less than 1 KB!
Before: 62.1 KB
After: 61.5 KB
Please find them in the attachments!
Julie Carson
Mar 26, 2018Copper Contributor
Thank you. I did the test too, but I think there were skeptics working with me and wanted a second opinion.
- Haytham AmairahMar 26, 2018Silver Contributor
If so, I would recommend you to send my previous reply to them via email!
Good luck