jmacleary
Well-known Member
- Joined
- Oct 5, 2015
- Messages
- 1,060
- Office Version
- 365
- 2007
- Platform
- Windows
Hello folks.
Hopefully quite simple. I have a spreadsheet which has a table with an associated query, and some calculated columns. The query properties are set to'overwrite existing cells with new data, clear unused cells'.
The problem is that when the query returns 0 rows, the calulated formulae are lost. Is there a way to keep those formulae from being lost?
Thanks in advance
Hopefully quite simple. I have a spreadsheet which has a table with an associated query, and some calculated columns. The query properties are set to'overwrite existing cells with new data, clear unused cells'.
The problem is that when the query returns 0 rows, the calulated formulae are lost. Is there a way to keep those formulae from being lost?
Thanks in advance