MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Question from a newbie

  Asked By: Trupti    Date: Aug 23    Category: MS Office    Views: 1297

I have a problem and haven't been able to figure it out. Everytime I
open my excel, whether just the program or through one of my files, I
get a 'Subscript out of range.' message. If I have a workbook open
and then open another one, I don't get the message. I have no idea what
I did to cause this message or how to find out what to do to fix it.
I started getting it a couple months ago so I don't even know what
workbook the problem started in. Any help would be most appreciated.
I am running Excel 2000 Version 9.0.2720. Thanks. I tried looking
online and all the sites and help I found were over my head. I am
just a simple secretary.



4 Answers Found

Answer #1    Answered By: Faiza Mian     Answered On: Aug 23

Sounds like Excel has either on add-in installed or some Auto_Open code.
Bearing in mind what you said about opening another document, I'd guess an
add-in is at fault. Go to Tools_addins and uncheck boxes one  at a time and
se what works.

Answer #2    Answered By: Felix Gray     Answered On: Aug 23

I have not been able to find
anything like the add-ins you told me to look for under Tools. I have
gone through everything in my options and don't find  anything that
looks like it would be the problem. Any other ideas? I work on Excel
all the time but the most creative I have gotten was to link
information in one workbook  to another workbook, so, I am pretty
limited in my abilities. The sad part is that I am the most
proficient in my office. Any and all other suggestions accepted.

Answer #3    Answered By: Sultana Tabassum     Answered On: Aug 23

Just to clarify, did you go to the Add-ins dialog from the Tools menu and
find nothing checked there? Because if not (it's not clear from what you say
whether you got to the dialog or not) that would still be my first choice
for what's giving you a problem.

Answer #4    Answered By: Hollie Hughes     Answered On: Aug 23

Did you get your problem  solved yet?

If not can you please indicate when getting this error message, what
options do you have to select on this error dialog box?

Didn't find what you were looking for? Find more on Question from a newbie Or get search suggestion and latest updates.