Open Excel 2000 file ?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

JerriS

Thread Starter
Joined
Sep 27, 2000
Messages
41
On an HP Brio pc running Win98SE with 64mb ram using Office 2000, user opens a spreadsheet in Excel that contains 3 worksheets and macros and Excel opens multiple sessions. Any idea on what could be causing this? We have tried opening the same file on another pc and same thing happens.

Thanks
 
Joined
Oct 29, 2001
Messages
2,056
do you mean multiple sessions of the <u>same</u> file, or one session of the file and additional sessions of the default workbook/sheet?

sounds like either something in the suspect file - you said it had macros in it, what are they supposed to do? - or something in the start up.

more info would help

and from the dreamboat:
<i>Excel closed.

Start-->Run and type:

Excel.exe /regserver

And/or run repair from Excel's help menu if 2000 or greater.</i>

-was in reference to a different prob, but it could help here too.
 
Joined
Dec 8, 2001
Messages
270
One other possible thing to check - because Microsoft Excel will attempt to open every file in the additional startup folder, make sure you specify an empty folder or a folder that contains only files that Excel can open.

Steps:
On the Tools menu, click Options, and then click the General tab.
In the Alternate startup file location box, see what is specified.
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
To clarify for jbcalg, and also Alan (who I'm sure is aware of this):

When files open unexpected on OPEN OF EXCEL, that usually indicates one of two things:

1. There are files in the folder called XLSTART, usually on your hard drive. Close Excel, find the folder and move any files out of it, they don't belong there if you don't know WHY they're there. Also, macro VIRUS files tend to write themselves there, so if you ever suspect one....

2. The user has indicated a location, as Alan stated, and on OPEN OF EXCEL, the files in that folder will open.

However, if you open Excel with NO problem, the macros in the workbook could be causing these events. To open a workbook WITHOUT running macros, hold the SHIFT key while double-clicking the file to open. I believe this still works in all versions. If not, Tools-Macros-Security and set it to High to keep macros from running automatically.

jbcalg, this problem wouldn't indicate registry settings to me. They are more for toolbars that can't be restored, illegal ops or other errors AFTER hard drive cleanup has been done and startup folders have been checked, won't keep it's settings, can't think of anything else off the top of my head. Just to let ya know...
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top