View Single Post
  #2  
Old June 5th, 2010, 08:44 PM posted to microsoft.public.excel.misc
Stan Brown
external usenet poster
 
Posts: 536
Default No formulas Work

On Fri, 4 Jun 2010 21:04:36 -0700, BG Mark wrote:

For some reason none of hte formula in a spreadsheet are working. The
spreadsheet is on a netowrk and when others open it, the formulas work. When
I open the spreadsheet on a simple addition formula I get the #value
appearing in the cell. Is there a setting in excel that I need to change.


Do you in fact have access to the network resource that is referenced
from the workbook?

Do you have Analysis Toolpak add-in loaded, if the workbook requires
it?

Which version of Excel do you have, including Service pack (SP)
number?

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...