Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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

0
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.   [url]https://docs.google.com/spreadsheets/d/1RKnjaCYR6yubYV207NcrH21J_b_HVvudm-0GZeXWFEo/edit?usp=sharing[/url]

you can download the excel file from here: https://drive.google.com/file/d/1g5sKGXZQh94-rv4kT2aG43Och_C92a_g/view?usp=sharing

Answer
Discuss

Discussion

Hi Yaseen.

If I compare your workbook in Google Sheets and Excel (2016), they look nearly identical.

Are you talking about the formula in cells in the "Shipment Details" sheet? If so (or not), please edit your question to give details so we might follow your problem.
John_Ru (rep: 6092) Jan 27, '21 at 12:28 pm
Yes, Also the data mainly grabbed from the "Forecasting" tab and in the "Shipment Details" sheet on my laptop i see it like this https://prnt.sc/xpyze6
yaseen381 (rep: 2) Jan 27, '21 at 12:31 pm
So I see the same (in Sheets and Excel), blanks cells in columns E and F of Shipment Details.

I may not be able to help you but you should still edit your question so others can understand (they won't always read discussions). You can attach an Excel file when you edit (using "Add files to post" under the question I think)
John_Ru (rep: 6092) Jan 27, '21 at 12:41 pm
Add to Discussion

Answers

0

This sounds like a matter of permissions. When you open a file on your Windows platfoprm for the first time Excel will, in fact, open it in Safe mode. There are two steps from there. One is to enable editing and the other to enable macros, if it's an xlsm file. Normally, you would be asked whether you wan to permit either and the workbook will remain inoperable until you do. Once you grant permission and save the file Windows will remember and not ask again for that file.

This is, of course, a protection against possible viruses in imported files such as you might download or receive by email but it may reasonably also be applied to any other files you open for the first time. The solution lies in your security settings. Somewhere there must be a switch that instructs Windows, Office or Excel to suppress the security procedure. This would cause the two questions not to be asked which would enable you to exit Safe mode and start working withn your files in the normal way.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login