Ardhendu Sarangi
asked on
Excel 2010 Personal.XLSB stopped loading at startup. Strange Problem Indeed.
Hi All,
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.
C:\Users\Ardhendu\Applicat ion Data\Microsoft\Excel\XLSTA RT
C:\Users\Ardhendu\AppData\ Roaming\Mi crosoft\Ex cel\XLSTAR T
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?
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.
C:\Users\Ardhendu\Applicat
C:\Users\Ardhendu\AppData\
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Something has changed or else you wouldn't suddenly lose functionality would you ;-)
ASKER
@Rory,
i checked the add-ins too no luck. right now i am using personal.xlsa file which is working for now
i checked the add-ins too no luck. right now i am using personal.xlsa file which is working for now
Can I just check where specifically you looked, because your symptoms are exactly what you would get if the file were disabled?
ASKER
hi rory,
i checked under the Disabled Items drop-down under Add-ins. Finally i check the file and it was set to read-only. I unchecked it and it seems to be working now.
this was quite a strange fix...
i checked under the Disabled Items drop-down under Add-ins. Finally i check the file and it was set to read-only. I unchecked it and it seems to be working now.
this was quite a strange fix...
ASKER
Thanks for the responses, guys!
ASKER