Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Raju Iyer   on Feb 07 In MS Office Category.

  
Question Answered By: Aaron Kennedy   on Feb 07

Okay, well I figured out how to take care of the earlier question I had about
the Vlookup formula, and you're right ... so that's all taken care of.

I have another problem that I could use some help on however.

The file I'm using the Vlookup formula in is about 8.4 MB in size. When I try
to do sort functions, and sort several thousands of rows of data, I get a
message back saying the clipboard cannot be opened. If I sort a smaller portion
of the data  -- say 3000 rows or so -- and go to save it, I get a message that
comes back saying Data Not Saved.

Can someone tell me what the problem is I'm having here?

I have 224 MB of RAM and a 40 GB hard drive of which only 6 GB or so is being
used. I'm running Windows XP Home Edition and am using an older version of
Excel -- from Office 97.

Also, and this is really frustrating too, but every 15 minutes or so when I'm
working on this spreadsheet I have a window that pops up saying something like
"Microsoft Excel has encountered a problem and needs to close." Needless to
say, I always lose my unsaved data.

Any suggestions?

Share: 

 

This Question has 9 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on "If/Then" statement in Excel Or get search suggestion and latest updates.


Tagged: