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.