Cyberdude
01-25-2010, 12:52 PM
The Windows 7 explanations shown in the Microsoft button display are:
XLS . . . . . .an Excel workbook
XLSM. . . . .XML-based and macro enabled file format
XLSB . . . . binary file format optimized for fast loading and saving
It would seem that maybe XLSB might be the preferred file name extension. But can it use macros?
]Apparently XLSM is not prevented by security from using macros, but will take longer to load and save than XLSB will.
XLS is probably prevented from using macros unless you go in and change the security settings to allow the use of macros, but is otherwise just like XLSM.
So which name extension is preferable as a general choice? I’m guessing that fast loading and saving is not an important factor for most applications, so IF your application is using macros or is likely to use them in the future, XLSM is the best choice. I’m also guessing that, if you are not using macros, XLSM will use more memory than XLS, but otherwise won’t cause any malfunctions in your workbook.
What I don’t understand is how my PERSONAL.XLS seems to get loaded for some workbooks and apparently works just fine, even though it is loaded with macros.
Are my explanations above correct, or am I wrong about something?
XLS . . . . . .an Excel workbook
XLSM. . . . .XML-based and macro enabled file format
XLSB . . . . binary file format optimized for fast loading and saving
It would seem that maybe XLSB might be the preferred file name extension. But can it use macros?
]Apparently XLSM is not prevented by security from using macros, but will take longer to load and save than XLSB will.
XLS is probably prevented from using macros unless you go in and change the security settings to allow the use of macros, but is otherwise just like XLSM.
So which name extension is preferable as a general choice? I’m guessing that fast loading and saving is not an important factor for most applications, so IF your application is using macros or is likely to use them in the future, XLSM is the best choice. I’m also guessing that, if you are not using macros, XLSM will use more memory than XLS, but otherwise won’t cause any malfunctions in your workbook.
What I don’t understand is how my PERSONAL.XLS seems to get loaded for some workbooks and apparently works just fine, even though it is loaded with macros.
Are my explanations above correct, or am I wrong about something?