Windows 10 vs Windows XP - Excel Office 365 vs Excel 2010

ststern45

Well-known Member
Joined
Sep 17, 2005
Messages
814
Office Version
  1. 2010
Platform
  1. Windows
Hi everyone,

Wow I am really baffled after upgrading to Microsoft 365 Excel.
Formulas don't calculate in my Windows 10 64 bit machine.
A simple index/match formula gives me the same result in a column. Whereas on my Windows XP Excel 2010 the same formula works to perfection.
Not sure if this is the reason but I have both Excel 2010 and Excel 365 installed on the same Windows 10 computer.
Any ideas on why the formula will not calculate?
The formula example, index($A$1:$A$100, Match($C1,$B$1:$B$100,0)) Cell C1 = ACD
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

StephenCrump

MrExcel MVP
Joined
Sep 18, 2013
Messages
4,117
Office Version
  1. 365
Platform
  1. Windows
What do you mean by gives me the same result in a column?

It sounds like you're describing the new Excel 365 dynamic functions, and the spilling of a formula into adjacent cells? But the Index/Match formula you've posted won't spill.

When you say, the formula will not calculate, what exactly do you mean? Does it give you a result you think is incorrect? Show as a formula rather than a calculated result? Or what?
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,391
Office Version
  1. 365
Platform
  1. Windows
One possibility is that your 365 is set to Manual calculation of formulas instead of Automatic. Have a look in File -> Options -> Formulas -> Calculation options
 

ststern45

Well-known Member
Joined
Sep 17, 2005
Messages
814
Office Version
  1. 2010
Platform
  1. Windows
Thanks for the replies.
The formula worked when I did the following and I'm not sure why.
I did have the option set to automatic no manual. That is, I never changed this option.
The cells in the column originally had alpha characters and I wanted to change these cells with the index/match formula. I deleted all the alpha characters in the cell range and also removed any formatting in all the cells. The only formatting was was a "border" in all the cells so I removed the borders. So this gave me a "clean" if you will cells in the column cell range. I re-entered the index/match formula and it calculated correctly. I'm not sure if having a cell formatted with a border throws off the calculations or entering a formula in an existing cell that contained formatting.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,447
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
You still didn't explain exactly what you were seeing. Were you seeing the same formula result in every cell, or were you seeing the actual formula in every cell? The latter would suggest that the cells were formatted as Text initially.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,242
Messages
5,623,573
Members
415,981
Latest member
Baltwin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top