LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Functions Stopped Working

I have recently encountered the strangest thing in some of my Excel 2003
workbooks. The functions just stop working. I have a workbook with multiple
sheets and an array of formulas that all stopped displaying the formula
results. It almost seems like the cells have become corrupt. The formulas
are all correct as well. The only way I can get them to produce the result
is to enter into the cell (double click or F2) and press the enter key again.
MAGIC!!! the result displays. I cannot do this for thousands of cells and
multiple pages though. Even after I do, the formula will not update with a
new results unless I follow the preceeding step again. It's like Excel went
catatonic.

Has anyone else encountered this occurence? Is there a fix? Do I have to
rewrite my entire workbook?

Thanks in advance.

JD
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel has stopped working John C Harris Setting up and Configuration of Excel 0 February 23rd 07 03:48 PM
formula stopped working.... Ken Proj mgr Excel Discussion (Misc queries) 5 December 29th 06 03:57 PM
Web query has stopped working... andrewm27 Excel Discussion (Misc queries) 0 April 20th 06 05:28 AM
VB Stopped Working [email protected] Excel Worksheet Functions 1 April 28th 05 01:56 PM
excel stopped working Steve Excel Discussion (Misc queries) 0 January 13th 05 04:07 AM


All times are GMT +1. The time now is 01:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"