I have just "upgraded" to office 365 and having some problems with some old work books.
I use a lot of SQL lookups that are automated by macros. i have found, if the query returns no results any formula that refers to is is broken, with a #REF error.
I fixed this by changing refresh option...