LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Formulas do not generate result until formula edited

We utilize a multi-page workbook in Excel 2003. All updates are installed.
Recently, random formulas are not yielding a result, rather show a default -
for 'zero'. Not all formulas are the same type, e.g. round or sum, nor will
they necessarily repeat. Calculation is set to Automatic, no files have
Calculation set to Manual, no macros are used. F6 is depressed to refresh
formulas, but yields no result. Nor does F8.

Their are two methods we have found to yield a result: 1) edit the formula,
by replacing at least one character with the same character - generally we
replace the = sign with itself, depress Enter and the formula yields a
result; 2) right click the worksheet tab, copy to another sheet, and ALL
formulas yield results.
 
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
Lock formulas from being edited Tia[_3_] Excel Worksheet Functions 1 June 30th 08 05:37 PM
using a result of a formula to generate text in Excel 2003 THIRDCOAST Excel Worksheet Functions 2 January 29th 08 07:06 AM
Generate a random result... Lukerz Excel Discussion (Misc queries) 6 May 1st 06 12:01 PM
any possible way to generate a formula to get the same result ciccia Excel Discussion (Misc queries) 1 July 21st 05 03:20 AM
Formulas appear in cell instead of formula result tommcbrny Excel Worksheet Functions 3 November 30th 04 08:44 PM


All times are GMT +1. The time now is 05:57 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"