A word of caution for those who plan to use the excel files via browser only
There's a memory limitation issue if you have 2 spreadsheets and have a complicated formula like that of a lookup to always return last record from a column in spreadsheet1 to a cell in spreadsheet2. After 250+ rows it starts giving an error. The file will continue to work via one drive on excel desktop and excel mobile but not via browser sadly.
This is for any referencing between spreadsheets and depending on complication of the formula or activity the length might differ but it is definitely an issue.
There's a memory limitation issue if you have 2 spreadsheets and have a complicated formula like that of a lookup to always return last record from a column in spreadsheet1 to a cell in spreadsheet2. After 250+ rows it starts giving an error. The file will continue to work via one drive on excel desktop and excel mobile but not via browser sadly.
This is for any referencing between spreadsheets and depending on complication of the formula or activity the length might differ but it is definitely an issue.