Monday, November 16, 2009

Microsoft Excel help! Book.xlt keeps saving itself as my microsoft startup workbook! Is it a virus?!?

When i open a microsoft excel workbook, it auto opens 255 worksheet. Even after I adjusted the settings to 3 worksheets, after i close the workbook, the same thing happens again the next time i launch excel. There seems to be hidden macros running, and when i go to program files\microsoft office\office11\xlstart, i will find this book.xlt file in the folder. Even after i delete it, it will appear again the next time i launch excel. Gosh. Can anyone help? is this a virus? :(

Microsoft Excel help! Book.xlt keeps saving itself as my microsoft startup workbook! Is it a virus?!?
The .xlt files are templates--not workbooks--so editing your options to limit new files to 3 sheets will not work. Somewhere along the way a user created Book.xlt and saved certain settings with it...and you are reaping the benefits.





The procedure you use to open excel is calling a template, so you need a different procedure. If you have a shortcut on your desktop, I say delete it. Copy the shortcut from your start menu to your desktop, and test it. If you continue to have the same problem, check the macros in your Personal Workbook.





The Personal workbook is a hidden file that opens every time you run an Excel application, and there can only be one open at any time. If you do not have a macro stored in the Personal.xls workbook, and you are not calling Excel via a template shortcut....then it's time to uninstall/reinstall.
Reply:I had a look at Excel for this problem and cannot find anything.





Do an online virus check at this URL:





http://www.pandasecurity.com/homeusers/s...





Then download this, update and run it.





http://www.avira.com/en/pages/index.php





These should clear any visus you may have.
Reply:Open Excel, go to Tools, Options, General tab. Type in number of sheets you want in a spreadsheet, and click on OK. close Excel and then open it again, you may try opening the problem spread sheet and then copy those sheets you want into the new one, you can add new sheets if required, then save it with a different name, close Excel and then re-open the new file. you can rename it to the old file later. the format of your problem file may be defaulted to 255 sheets in the file, in its option record..
Reply:it may be a virus, or just a problem with Excel. i'd suggest doing a system restore to before you started having those problems. system restore is in program files


No comments:

Post a Comment