Question about Microsoft Office Excel 2003 for PC

2 Answers

Whenever I open a new spreadsheet now it automatically opens up a spreadsheet calles PERSONAL. Why is that and how can I get rid of it... I think it started after a did a macro but I am not sure. Thanks, Martin

Posted by on

Ad

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 3 Answers

You're right - it was caused by recording a macro. When you record a macro you are given the option to store the new macro in "This Workbook", a "New Workbook" (the default), or in a "Personal Macro Workbook". It looks like you selected "Personal Macro Workbook".
The recorded macro is stored in a special workbook called "Personal.xls". This workbook is loaded every time Excel is loaded. If you don't want this workbook loaded, then just delete it or rename it.
The file is buried deep in Microsoft's application data area. On my Vista computer it's in C:\Users\frogfund\AppData\Roaming\Microsoft\Excel\XLSTART On my Windows XP computer it's in C:\Documents and Settings\frogfund\Application Data\Microsoft\Excel\XLSTART. Depending on your computer your Personal.xls might be in a slightly different location. You might need to do a search using Windows Explorer.
If you are still having troubles finding personal.xls 1. Open Excel, 2. Open the Visual Basic editor (hit Alt-F11 or click Tools-Macro-Visual Basic Editor) 3. Click Tools-References to bring up the references dialog 4. Click on VBAProject in the list. The file location will be displayed near the bottom of the dialog box. Sometimes this might be cut off at the end, but it should give you a good idea where the file is located. 5. Click Cancel to close the dialog.

Posted on Oct 20, 2009

Testimonial: "Thank you, I see that I have much more to learn about working with macros:). Thanks, MaArtin."

Ad
  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 175 Answers

Anypasskey Excel Password Recovery is Professional utility works on Password recovery, it can recover all versions of EXCEL files quickly and efficiently, and its previous versions and easily get Excel password reset. It deserves trying.

Posted on Nov 30, 2011

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

When i open an excel spreadsheet, the columns go right to left instead of left to right.


  1. Click Options on the Tools menu, and then click the International tab.
  2. Do one of the following in the Right-to-left option group.
    • Click Right-To-Left to have new objects displayed in a direction familiar to right-to-left users.
    • Click Left-To-Right to have new objects displayed in a direction familiar to left-to-right users.

Nov 10, 2013 | Microsoft Excel 2010

1 Answer

Spreadsheets


To open a spreadsheet 'FILE' you need a spreadsheet 'PROGRAM'. Unfortnately Apple don't give you one free anymore so you will have to buy one. Apple Numbers (part of iWork) or Microsoft Excel (part of MS Office) or you can download a freebie from the open office people.

Feb 12, 2012 | Apple Computers & Internet

1 Answer

How to open excel sheet in different window?


While one spreadsheet is open in Excel, open the second spreadsheet as follows:

Go to Start, Programs, Excel (or however you navigate to Excel). Then in the new Excel window select FILE, OPEN, then your 2nd spreadsheet.

Mar 29, 2011 | Microsoft Windows XP Professional

4 Answers

Solution for Excel 2003 "the file is not in a recognizable format"


If you open an excel created by M/S Office 2007, Excel 2003 will not be able the file. You have to install Microsoft Office the "Compatibility Pack for Word, Excel, and PowerPoint File Formats" for M/S Office 2003 from Microsoft Site.

or

Your Excel file is corrupt!

Hope it helps.


Oct 01, 2010 | Computers & Internet

1 Answer

Whenever I try to print a spreadsheet I get a message; "Out of memory. Save or close any open files or applications" - after I close the spreadsheet I get a message: "the document and printer setting do...


You could try a disk clean.
Start>all programes>accessories>system tools>disc clean up. this will make space on you PC, could also do a defrag to help speed up your PC.

Aug 30, 2010 | HP Office Equipment & Supplies

1 Answer

Word automatically updates documents


Get rid of the date field. Just type the date instead.

You can set your personal options to not update the fields under Word Options, but it doesn't stop it from updating on someone else's computer.

Oct 03, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Printer "out of memory"


So which printer are you wanting help with?

Nov 23, 2008 | Office Equipment & Supplies

1 Answer

Not able to enable password login


Firstly start by opening your run box and enter control userpasswords2

When the user accounts window opens, check the box which states 'Users must enter a username and password to use this computer' and apply the setting.

You will be requested for the username and password of the account you wish to automatically logon as for following reboots of your system.

Jun 24, 2008 | Dell Latitude D600 Notebook

1 Answer

Consolidate few sheets under 1 excel


What version of Excel are you working with. Newer versions allow you to have multiple spreadsheets grouped together into what is called a, "Workbook." To view the sheets separately, you simply click on the tabs at the bottom of the workbook. The easiest way I know of to join spreadsheets together into a single workbook is to open all of them at the same time, then choose, "View / Arrange All," and they'll be small, but you can grab each one by its tab and drag it to the workbook you want them in. Then you save the workbook (give it a new name like, "Accounting Roll-UP," or, "Consolidated Books," or whatever best describes it) making sure to close all the (now empty) spreadsheets without saving your changes to them (or else you'll lose your 'back-up' data). Voila! You open one file, and all your spreadsheets are available with the click of a mouse.

Dec 18, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Excel 2003 for PC Logo

175 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2845 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18402 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...