Spreadsheet issue
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? |
Spreadsheet issue
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. -- Cheers, Ryan "LeisaA" wrote: 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? |
Spreadsheet issue
No, just 4 columns Three text and 1 hyperlinks.
"Ryan H" wrote: 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. -- Cheers, Ryan "LeisaA" wrote: 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? |
All times are GMT +1. The time now is 01:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com