Can't help with MAC - haven't never used it. What character coding is MAC using - ASCII or something other? I'm asking, because you mentioned Excel asking about you wanting to enter formula. Suspiciously like it doesn't recognize '='!

You use both MAC and Windows computers? Have you tried do all (started from entering formulas) using Windows computer only?

Hi, I tried doing everything from the start but some of the things you did are happening in the background that I can't work out. As advised by p45cal I will try to download files directly to Windows computer. Maybe that will make difference. Can't do it right now as my work uses protected server that will not allow me to access external forums.
Just about the information disappearing from the table - the formulas are still there, just results are hidden. I know they are there as they flash momentarily when the new data is entered.

The only thing not entered directly into formula is defining the Name nDates, which represents the range Report!$C$1:$L$1. In my Excel, I can define name selecting from Main menu Formulas>[Name Manager]. Btw. There you'll find also all Defined Tables, and all DataRanges of ODBC queries in case you have defined them for this file.

Btw. I added here an example, how make it even more 'background'

Attached Files

leave schedule.xlsx (26.7 KB, 5 views)