Spreadsheet issue

[LeisaA]

I have a spreadsheet, 10,503 KB that has 3699 rows and 3600 of them have
hyperlinks in them. It takes a lot of time to save this document. I do have
it saved as an .xlsm due to two macros used in the spreadsheet. Will things
improve if I save it as a .xlsx and will I lose the anything related to the
macro or just the ability to run the macro?

 

[Ryan H]

There shouldn't be a big difference in file size with .xlsm vs. .xlsx.
Unless, your macros are huge with lots of userforms. If you save as a .xlsx
you will lose access to your macros. Do you have lots of objects in the
workbook. Objects such as buttons, controls, pictures, shapes, more than
3600 hyperlinks, etc? That will certainly fill up your workbook.

 

[LeisaA]

No, just 4 columns Three text and 1 hyperlinks.

There shouldn't be a big difference in file size with .xlsm vs. .xlsx.
Unless, your macros are huge with lots of userforms. If you save as a .xlsx
you will lose access to your macros. Do you have lots of objects in the
workbook. Objects such as buttons, controls, pictures, shapes, more than
3600 hyperlinks, etc? That will certainly fill up your workbook.