Forum Discussion
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...
Hi Julie,
Hyperlinks aren't any different in size to the texts that created them and although it will increase the file size by 1 or 2 times compared to its visible text. So, I wouldn't worry about the file size increased if it is increases only using =Hyperlink( , ) function.
However, some folks are usually mistaken between pasted hyperlinks and hyperlinks using Hyperlink function. If user has numerous hyperlinks using pasted links then that for sure increases the size of workbook significantly and plz allow me to demonstrate here:
Open an empty Excel file and enter a text e.g. Myfolder there and then right click and click hyperlink and then select a folder as the address of the hyperlink C:\Users\Julie\Downloads\ and then save the workbook somewhere
then open a new workbook and type this somewhere =Hyperlink("C:\Users\Julie\Downloads\","Myfolder") and save in the same folder as the first workbook.
If you check the size of the above two workbooks, you will see that the second workbook is smaller in size than the first one. This was just one hyperlink, if you have many hyperlinks the difference of size will be significant.
Whenever linking cells either with a folder or file, instead of copy and Paste (control + v ) use paste-values only and create link using hyperlink() function and this way it will open quickly and will not increase file size.
Hyperlinks aren't any different in size to the texts that created them and although it will increase the file size by 1 or 2 times compared to its visible text. So, I wouldn't worry about the file size increased if it is increases only using =Hyperlink( , ) function.
However, some folks are usually mistaken between pasted hyperlinks and hyperlinks using Hyperlink function. If user has numerous hyperlinks using pasted links then that for sure increases the size of workbook significantly and plz allow me to demonstrate here:
Open an empty Excel file and enter a text e.g. Myfolder there and then right click and click hyperlink and then select a folder as the address of the hyperlink C:\Users\Julie\Downloads\ and then save the workbook somewhere
then open a new workbook and type this somewhere =Hyperlink("C:\Users\Julie\Downloads\","Myfolder") and save in the same folder as the first workbook.
If you check the size of the above two workbooks, you will see that the second workbook is smaller in size than the first one. This was just one hyperlink, if you have many hyperlinks the difference of size will be significant.
Whenever linking cells either with a folder or file, instead of copy and Paste (control + v ) use paste-values only and create link using hyperlink() function and this way it will open quickly and will not increase file size.
Hi Jamil,
In some cases, the size will vary slightly and this difference will not have a significant impact even if the number of links increases.
This is in case if the link is external!
Please see the attached files.
It may also be different if these links are duplicate and external as in the case I mentioned earlier, and how the links in the HYPERLINK function have increased the size of the workbook by about 30 KB.
This may be thanks to the sharedStrings.xml which is has the responsibility of reducing the size of the hyperlinks strings.
Not always the hyperlinks in HYPERLINK function are lower in size!
