Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / June 2008



Tip: Looking for answers? Try searching our database.

Excel does not compute

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PBradley@officeformac.com - 27 Jun 2008 17:36 GMT
Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

When I enter data into a spreadsheet (in this case and expense form), the formulas do not work. Instead I get an "empty cells" warning. If I re-enter the formula, it updates total at that time, and I have to do this every time I enter or change the numbers.
I recently updated to Leopard.
Bob Greenblatt - 27 Jun 2008 19:27 GMT
On 6/27/08 12:36 PM, in article 59b528eb.-1@webcrossing.caR9absDaxw,

> Version: 2004
> Operating System: Mac OS X 10.5 (Leopard)
[quoted text clipped - 5 lines]
> enter or change the numbers.
> I recently updated to Leopard.
I calculation set to automatic? Go to preferences and select calculation.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Barry Wainwright - 28 Jun 2008 22:38 GMT
> On 6/27/08 12:36 PM, in article 59b528eb.-1@webcrossing.caR9absDaxw,
>
[quoted text clipped - 10 lines]
>
> I calculation set to automatic? Go to preferences and select calculation.

alternatively, is there a circular reference in the sheet ? (you would
get a warning when you open the workbook if there is). The existence of
a circular reference would prohibit automatic calculations.

Signature

Barry Wainwright
Microsoft MVP

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.