Updates of Calculating Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a spreadsheet that some linking to other sheets in the
workbook. One of the sheets has calculations being processed on linked data.
I can not wright my first formula and then do a "FILL DOWN" for all 34
fields. The fill function fills in with the value of the first field even
though the formula bar shows the calculation for that field. If I open a
blank workbook this fill function works fine and all fields have their own
values. Also, once data has been entered and I go back and change the data,
the field will not update to reflect the calculation. It is not a
complicated calculation at all. Just calculating percentages.
 
Go to tools>options>calculations and make sure calculations are set to
automatic

or press F9 to force a calculation if you need them to be manual

Regards,

Peo Sjoblom
 
Hi
goto 'Tools - Options - Calculate' and enable 'Automatic calculation'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Calculate After hours 3
2007 Pivot table Calculated field misbehaving 1
Workbook will not update after pasting data 2
How can I change the formula for multiple cells at once? 2
Importing Access DB into Excel changes my calculated fields in Exc 3
Machine-readable passport calculations 7
Calculated Fields in Pivot Table 2

Back
Top