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 from
"insert cells for new data, delete unused cells"
to
"Overwite existing cells with new data, clear unused cells"
however I have noticed that if the query returns no rows sometimes the query itself is completely cleared with no way of rerunning it.
Looking for any advise if possible?
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 from
"insert cells for new data, delete unused cells"
to
"Overwite existing cells with new data, clear unused cells"
however I have noticed that if the query returns no rows sometimes the query itself is completely cleared with no way of rerunning it.
Looking for any advise if possible?