I have a unique problem to narrate. Hopefully someone will have a solution for this. Since yesterday, my personal.xlsb file does not automatically open when excel 2010 starts. I have tried to delete and recreate the file but no luck.
I can confirm that XLSTART folder has not been moved or changed in anyway. I am using Windows 7 and these are the folders that have been defined in Excel.
I checked the macro security and made sure it is not set to high too.
I went to Advanced options on the general section and put the XLSTART directory in the "At startup..." section. I did it and it doesn't help to kick start it either.
Finally, I found out that if I change the extension to .xlsa the file works .xls or .xlsb does not and .xlsm gives an error message.
My personal file has been starting up fine for years now (Excel 2003, 2007, 2010). And the macros have run nearly every day. What could have caused this sudden change? Can anyone help?