Regional Settings in Windows generates errors in spreadsheets

khavusr

New Member
Joined
Mar 10, 2016
Messages
8
Office Version
  1. 2021
Platform
  1. Windows
I've notices a few times over the years that having a Windows system with regional settings that differs from what the spreadsheet was originaly was created with causes date format and formulas to break and generate errors in spreadsheet. My question is if it's possible to load a spreadsheet and force the original 'regional settings' to be kept without enforcing the the regional settings to ensure that spreadsheets works as intended based on that I recently stumbled over this issue again. In this particular case I'm printing filofax inlays which is based on Word document which is merged with a excel spreadsheet to generate the calender pages to be printed. So in my case if I open the specific spreadsheet using the bellow settings:

Screenshot 2023-03-14 232706.png


The above mentioned spreadsheet open ups with tons of errors:

excel_errors.png


But, if I change the regional settings to use UK then it open fine without errors:

Screenshot 2023-03-14 232551.png


So back to the question, how to I open a spreadsheet without having to change regional settings back and forth which is just frustrating and to be honest how did Microsoft come to the conclusion that this was the way to do it.... but thats another question for another forum.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Hi,
Could the following help for Text In Swedish and in English :
=PROPER(TEXT(TODAY(),"[$-041D]dddd dd mmmm yyyy"))
and
=TEXT(TODAY(),"[$-809]dddd dd mmmm yyyy")
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

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
Back
Top