Re: Excel 2000 large files losing formulars...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Niek,

Thanks for the info, I will check this setting. In addition, I will verify
your info below...


"Niek Otten" <nicolaus@xxxxxxxxx> wrote in message
news:uij19MmLGHA.2668@xxxxxxxxxxxxxxxxxxxxxxx
<don't work anymore>

Tools>Options>Calculation, check Automatic

<they can't add new ones >

What do you mean they can't? What happens if they try? Don't they
calculate? Is there an error message? Unexpected results? Typing but not
seeing anything?

--
Kind regards,

Niek Otten

"Ivan T. Williams" <itw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uQ9rBGmLGHA.1180@xxxxxxxxxxxxxxxxxxxxxxx
...well, I've just confirmed with the user, the formulas are there, they
just don't work anymore, and they can't add new ones either.
Funny thing is, it's not consistent, we've tested other Excel files, and
they seem fine. Now, if they reboot, it MAY work, but in most cases it's
a few days before they miraculously start working again...

All the latest service packs/updates for Office 2000 are loaded too...

"Niek Otten" <nicolaus@xxxxxxxxx> wrote in message
news:OodEo8lLGHA.2036@xxxxxxxxxxxxxxxxxxxxxxx
What do you see if you "lose the formulas"?

--
Kind regards,

Niek Otten

"Ivan T. Williams" <itw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:u1e9G7lLGHA.532@xxxxxxxxxxxxxxxxxxxxxxx
Ok, this is a serious issue. In our accounting department we're using
Excel 2000, but on some files (25k -63k) from time to time it would
lose the formulas or we'd get an error when we try to save, "not enough
memory"

We're on Win2K, 1GB memory. But, does anyone know how to correct this?









.

Relevant Pages

  • Re: Excel 2000 large files losing formulars...
    ... cells. ... Kind regards, ... they just don't work anymore, and they can't add new ones either. ... We're on Win2K, 1GB memory. ...
    (microsoft.public.excel)
  • Re: Excel 2000 large files losing formulars...
    ... Is there an error message? ... Kind regards, ... just don't work anymore, and they can't add new ones either. ... We're on Win2K, 1GB memory. ...
    (microsoft.public.excel)
  • Re: Excel 2000 large files losing formulars...
    ... just don't work anymore, and they can't add new ones either. ... Funny thing is, it's not consistent, we've tested other Excel files, and ... Kind regards, ... We're on Win2K, 1GB memory. ...
    (microsoft.public.excel)
  • Re: Software will not run with more than 512MB RAM installed
    ... > The following error message appears every time I attempt to open a ... > Windows ME, Windows XP ... > Total Physical Memory 1,024.00 MB ... > with 64MB RAM, no error. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Blue Screen of Death HELP
    ... I have now disabled automatic restart and await the next recurrence. ... The memory stick DDR2 was replaced when the problem arose but it was a 'pre-owned' stick which functioned after install and well before the problem. ... the My Computer icon on the Desktop and select Properties, Advanced, ... Same question applies to the other error message. ...
    (microsoft.public.windowsxp.general)