Solved My Office Excel is working abnormally.

April 5, 2013 at 03:39:19
Specs: Windows XP
My Office Excel 2003 is working abnormally. Every time i open an Excel file, a saved one or new one, Excel opens with another sheet which is in one of the old saved files under "personal" and I am having to delete it every time before I proceed to do any work on the new file. It opens every time with the same sheet and I think it is for this reason that it is making Excel slow to open. Could it be anything to do with Macro writing that i tried some time ago? Any advice to sort this annoying problem will be highly appreciated.


XEL-LEARNER


See More: My Office Excel is working abnormally.

Report •


#1
April 5, 2013 at 04:34:02
✔ Best Answer
It's possible that the "macro writing" you tried is causing this, but we can't say for sure unless we knew what code you wrote and whether it is still running or not.

When you say that Excel "opens with another sheet" do you mean it opens another workbook or that it adds a sheet to the workbook you are opening?

If it's a second workbook, then it sounds like you may have unhidden a workbook that used to be hidden. (personal.xls is usually hidden so that you don't see it when open Excel)

It could also be that you stored a file in your xlstart folder which will open whenever you open Excel.

If it's adding another sheet to all of your workbooks then I'm not sure what's going on.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
April 6, 2013 at 03:45:02
Thank you very much for your prompt response Derbydad03. Just to explain in more detail: I had a file called Europa with a single worksheet and which I had saved about a year ago. After this problem that I am trying to resolve started i.e. whenever I start a new workbook or I open another saved file these would open in Excel but with "Europa" opening as well every time as an additional worksheet as "Personal". Because it was so irritating I deleted "Europa" altogether but even now when I start a blank file or open a saved one it still opens with this worksheet. After your suggestion I hid the worksheet when it opened but now when I open a file Excel still opens with an additional worksheet as "Personal" but this time it is blank with no data showing, presumably because I have hidden the "Personal" worksheet. I forgot to mention earlier that I had also unstalled Office and re-installed to try and get rid of the problem but it is still there. How do I find out if I have accidentally saved the rogue file in "xlsstart"? I have just searched the folder with no result.. Thanks for your help.

Report •

#3
April 6, 2013 at 05:58:23
I'm still not sure that we are on the same page as far as the terms we are using. Let me define two terms and then ask that you use these terms when explaining what is happening. Keep in mind that I can't see what is going on with your system from where I'm sitting.

Workbook: an Excel document containing one or more worksheets, typically with an extension of xls, xlsm, xlsm, xlsm, etc.

Worksheet: the individual sheets within an Excel workbook, represented by the tabs in the workbook.

Now, using those terms (not "file") please explain whether Europa and personal are opening as worksheets within the workbooks you are creating/opening (i.e. they appears as a tab in the workbook) or opening as separate workbooks.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
April 6, 2013 at 07:40:47
Thanks again for responding so quickly. Actually following your first suggestion there was a "workbook" called "Personal" saved in the "xlstart" folder. I have searched and found the folder and deleted the workbook. I spelt the folder name incorrectly the first time I searched and that is why it came with no result. Excel now works fine and as it should. You have been a great help Derbydad03 once again. You have cured what was a really irritating problem for me. Many thanks once again.

XEL-LEARNER


Report •

#5
April 6, 2013 at 11:16:14

Report •

Ask Question