DAFC.net
Home 18 April 2024 
 Post Message  |  Top of Board  |  Search  |  Log In   Forum Rules  |  Newer Topic  |  Older Topic  |  end 
[ please login to use the Like feature ]
 Excel problem?
Topic Originator: PARrot  
Date:   Tue 5 Jun 11:26

Entering +^ + << - <
So plus F1 plus D2 minus E2 enter.
Formula reads ok in the cell and has always worked before but for some reason, despite the formula being indicated as ok, I am only getting the correct result if i go down the sheet repeating the entries.
If i drag down the corner of the cell it should copy the formula....and it does, but im getting the data from the original cell instead of the result.

Any suggestions?
[IP address logged]
Report Abuse   Reply To This Message
 Re: Excel problem?
Topic Originator: PARrot  
Date:   Tue 5 Jun 11:27

This is happening on all my spreadsheets not just one file.
[IP address logged]
Report Abuse   Reply To This Message
 Re: Excel problem?
Topic Originator: londonparsfan  
Date:   Tue 5 Jun 12:05

I'm not an excel expert but try:

Menu/Tools/CellContent/Autocalculate is on

It might be a starting point.
[IP address logged]
Report Abuse   Reply To This Message
 Re: Excel problem?
Topic Originator: aaaaaaaaaargh  
Date:   Tue 5 Jun 12:14

If you are in Excel 2007 or later, try:

Formulas -> Calculation options -> Automatic
[IP address logged]
Report Abuse   Reply To This Message
 Re: Excel problem?
Topic Originator: PARrot  
Date:   Tue 5 Jun 13:32

Thanks guys ill try that.
[IP address logged]
Report Abuse   Reply To This Message
 Re: Excel problem?
Topic Originator: PARrot  
Date:   Tue 5 Jun 13:46

Fixed. Brilliant thanks.
[IP address logged]
Report Abuse   Reply To This Message
 Re: Excel problem?
Topic Originator: londonparsfan  
Date:   Tue 5 Jun 14:20

Good stuff!
[IP address logged]
Report Abuse   Reply To This Message
 Re: Excel problem?
Topic Originator: Dalgety_Par  
Date:   Thu 7 Jun 14:22

Geek

It's common knowledge that Lionel Messi kept a photo of Hamish French by his bedside as inspiration every morning!
[IP address logged]
Report Abuse   Reply To This Message
 Top of Board  |  Forum List  |  Threaded View   Forum Rules  |  Newer Topic  |  Older Topic  |  end 

Rows: 0
 Forum List  |  Need a Login? Register Here 
 User Login
 User Name:
 Password:
 Remember my login:
   
 Forgot Your Password?
Enter your email address or user name below and a new password will be sent to the email address associated with your profile.
Security : type 'pars' in the box:
email:
© 2021-- DAFC.net