PC Review


Reply
Thread Tools Rate Thread

XLS Formulas work only in new documents, not in "open"ed ones !!??

 
 
The_Fakir_42
Guest
Posts: n/a
 
      7th Nov 2006
I have a very strange problem on excel 2003 (11.6355.6360) SP1

When I create any formula (eg: SUM(A1:A10)) in a new document, it
works. If I change values in A1 -> A10 it is update in real time.

If I save the document, exit Excel, then reload the document (thus
reloading Excel), the formula doesn't work anymore : the result is
stuck to the last value when I saved the document.
If I retype the formula, then it returns 0 whatever values are in A1 ->
A10.
If I select the cells A1->A10 with the mouse, I got the correct sum in
the status bar....
In tools->option, automatic compute is checked, and if I click on
compute now or compute document, it doesn't work.

If I save a document with no formulas in it, the reload it, I can
create formulas that work into it.
If I save a document with at least one formula in it, then reload it,
the formulas don't work anymore, and any new formula I create in it
doesn't work either...

If I send the document to a firend of mine who loads it into his excel,
it works !!!! so the problem is in Excel , not in the document.

I tried to repair office with no result.

HEEEEELLLLLPPPPP !!!!!

 
Reply With Quote
 
 
 
 
The_Fakir_42
Guest
Posts: n/a
 
      7th Nov 2006
Information complement :

If I save an empty document, then the first document I load just after works
fine.
If I uninstall and reinstall Excel, the first document I load just after
works fine.

I found no viruses or spyware on my computer...

Very strange....

Any idea ??


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook 2003- Getting the same emails - Not new ones, only old ones Bob Hatala Microsoft Outlook 1 5th Mar 2008 12:19 AM
XLS Formulas work only in new documents, not in "open"ed ones !!?? The_Fakir_42 Microsoft Excel Discussion 3 7th Nov 2006 05:00 PM
How big can the PST files be? (The old ones and the new ones) Juan I. Cahis Microsoft Outlook 12 10th Oct 2005 06:43 PM
The old ones are the funniest ones... Simon Brown Windows XP General 5 6th Mar 2005 03:46 PM
Creating Textboxes on the fly - new ones appear but the old ones do not =?Utf-8?B?SmFzb24gTQ==?= Microsoft C# .NET 2 20th Feb 2004 07:26 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:39 AM.