[mso] Re: Excel 2000: Lost formatting ability?

Hi Robert,
Excel has some functions that are limited by available memory, custom 
number formatting is one of them. In Excel 97 there was a quite small 
limit for formatting (256Kb, if I remember correctly). In Excel 2000 
I have never run against those limits, but I don't have worksheets 
with over 60.000 values either.
You might try typing this formula in an empty cell in one of the 
problem worksheets:
         =info("memavail")
And seeing what will it return.
If this a limit inside Excel, reinstalling Office will not solve your 
problem, you will have to reduce the size of your worksheets.
Wilson


At 02:41 23/4/2005,Robert Carneal wrote:
>I have tried:
>Reboot: Yes.
>Only file in Excel with this malady? Uh, yes and no. The files with *more*
>than 60,500 records are acting this way. My Most of my other files are 500
>records or so, and they are behaving.
>Protection? None. I made the file myself.
>Highlight the cells and copy/paste into a new file, does it still happen?
>Yes.
>
>McAfee (last update last night) says I am clean. Spybot{last update Apr 19}
>says I am clean.
>
>Removed my Excel addins with no improvement save a little faster by a few
>seconds.
>
>I am getting nervous I am looking at a reinstall of Office. I am going to
>redo my study tomorrow, so it will be later than usual when I check email;
>but suggestions comments, thoughts, ideas would be very much appreciated. (I
>don't want to reinstall office unless I have no choice.)
>
>Robert
>
>-----Original Message-----
>From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of
>Linda F. Johnson
>Sent: Friday, April 22, 2005 11:54 PM
>To: mso@xxxxxxxxxxxxx
>Subject: [mso] Re: Excel 2000: Lost formatting ability?
>
>Sorry about that first one...it just sent itself LOL
>
>Anyway...let's start with the obvious, Robert.  Did you try a reboot?  Is
>this the ONLY file in Excel where this is happening?  Are you sure the file
>isn't protected in some way?  If you highlight the cells and copy them and
>paste them into a new file, does it still happen?
>
>
>Linda
>Linda's Computer Stop
>http://personal-computer-tutor.com
>ABC Free Ezine ~ Free Ebooks and Tutorials
>*all outgoing mail scanned by Norton AV.  If you got a bug that looks like
>it came from me, it did NOT!
>
>-----Original Message-----
>From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
>Of Robert Carneal
>Sent: Friday, April 22, 2005 11:37 PM
>To: mso@xxxxxxxxxxxxx
>Subject: [mso] Excel 2000: Lost formatting ability?
>
>I am using Excel 2000, with a fairly large sheet. Several columns are
>formatted as date/time, but I want the date only. When I highlight the cell
>and click Format, the format options do not appear.
>
>Now I am wondering; could my sheet have too many formulas, too much data,
>etc., that Excel cannot offer me the format options for cells? If not, how
>do I fix this?
>
>Using a 4g processor, with 4g memory.
>
>Thank you.
>
>Robert
>
>
>*************************************************************
>You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
>MicrosoftOffice@xxxxxxxxxxxxxxxx
>
>To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
>To Unsubscribe from this group, send an email to
>mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
>in the subject line.
>
>Or, visit the group's homepage and use the dropdown menu.  This will also
>allow you to change your email settings to digest or vacation (no mail).
>http://www.freelists.org/webpage/mso
>
>To be able to use the files section for sharing files with the group, send a
>request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
>with instructions.  Once you are a member of the files group, you can go
>here to upload/download files:
>http://www.smartgroups.com/vault/msofiles
>*************************************************************
>
>*************************************************************
>You are receiving this mail because you subscribed to 
>mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx
>
>To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
>To Unsubscribe from this group, send an email to
>mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the 
>quotes) in the subject line.
>
>Or, visit the group's homepage and use the dropdown menu.  This will 
>also allow you to change your email settings to digest or vacation (no mail).
>http://www.freelists.org/webpage/mso
>
>To be able to use the files section for sharing files with the 
>group, send a request to mso-moderators@xxxxxxxxxxxxx and you will 
>be sent an invitation with instructions.  Once you are a member of 
>the files group, you can go here to upload/download files:
>http://www.smartgroups.com/vault/msofiles
>*************************************************************


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: