Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Filename reference in Spreadsheet XML issue | Excel Discussion (Misc queries) | |||
Excel Spreadsheet View Issue XP and 2003 versions | Excel Discussion (Misc queries) | |||
Spreadsheet Dating Issue | Excel Discussion (Misc queries) | |||
Loan Amoritization Spreadsheet Issue | Excel Worksheet Functions | |||
Generating content on the spreadsheet from an Add-on issue | Excel Programming |