Excel formulas not working on new installed window but working on other pc

[yaseen381]

Hi Everyone,
I had an issue with my excel file. When I open it on my Laptop (New installed windows and excel) it didn't work there, but when I open it on google sheets or on another PC it works fine. I tried calculating the formula "Calculate Now" button but no luck... The cell is in "General" nit "TEXT" so that's also not the issue. Can someone please please help me with this. I am attaching the excel file and also the online spreadsheet I imported the same file.

Working file

you can download the excel file from here: WindowAlert Forecast 01-26-2021 - US.xlsx

 

[Fluff]

Hi & welcome to MrExcel.
It would help us to help you, if you could supply a bit more information, like what is the formula, where is it & in what way doesn't it work?

 

[yaseen381]

Hi & welcome to MrExcel.
It would help us to help you, if you could supply a bit more information, like what is the formula, where is it & in what way doesn't it work?

Thanks Fluff for getting back to me, if you compare the both files, the online sheet and the other excel file you can download. See the screenshot attached it does not give me the vlaues you can see on your computer or on online file.

 

[yaseen381]

Also the data mainly grabbed from the "Forecasting" tab

Hi & welcome to MrExcel.
It would help us to help you, if you could supply a bit more information, like what is the formula, where is it & in what way doesn't it work?

 

[Fluff]

All your formulae work fine for me, on the forecast sheet do you see

 

[yaseen381]

All your formulae work fine for me, on the forecast sheet do you see
View attachment 30642

yeah that's the issue, you can see this and i can also see on another PC but not on my LAPTOP. do you know whats causing this? and how can i fix it?

 

[Fluff]

On your laptop do you see the data on the forecast sheet as shown above.

 

[yaseen381]

On your laptop do you see the data on the forecast sheet as shown above.

no i dont see the data on Forcasting tab "units to ship"

 

[Fluff]

Ok, the problem is going to be the "Potential Sell Thru" columns as they use IFS which you wont have using 2013 or 2016.
You will need to upgrade your version of office on the laptop, or change the formula.

 

[yaseen381]

Ok, the problem is going to be the "Potential Sell Thru" columns as they use IFS which you wont have using 2013 or 2016.
You will need to upgrade your version of office on the laptop, or change the formula.

Yesterday i downloaded the latest version of excel but it wasnt working, can you tell me the excel version i can use and which can fix the issue?