Excel saving sheet

[chaz]

Hello

I am in the process of creating a fairly simple sheet to bet on weight of money.

When i enter a formula on the BA sheet it works ok, but when i save the sheet there is an excel compatibility issue.

I have Excel 2019, when asked to save the sheet i have many options.
I chose excel with macros ? any advice on the best save format please ?
or maybe i am doing something else wrong, which is stopping the sheet working.


at the moment the formulas seem to work but where i enter the IF xyz Back [Column L] is dead

thanks in advance.

[ShaunWhite]

You can save it in either xlsx or xlsm depending of whether it contains macros. The only slight issue is that BA defaults to trying to load the old .xls format and you need to override it in order to find your workbook saved with the newer extension.

[chaz]

You can save it in either xlsx or xlsm depending of whether it contains macros. The only slight issue is that BA defaults to trying to load the old .xls format and you need to override it in order to find your workbook saved with the newer extension.

many thanks for your reply.

I shall also stop my bad habit of entering all formulas on one sheet.