svendiamond
Well-known Member
- Joined
- Jun 13, 2014
- Messages
- 1,504
- Office Version
- 365
- Platform
- Windows
I have a SQL query that updates through Excel (Data > New Query > From Database > From SQL Server Database) and I have some columns with formulas added. When I refresh the query, new rows are added and my formulas don't fill down automatically. I have to drag them down to get the formulas to fill. Also for some reason the final row always has the formula. It's just the ones in between that were added on the latest refresh. Any idea how I can get these rows to fill down automatically upon a new refresh? Here are some screenshots for reference. "Usage_Days" and "Err?" are columns with formulas - the "Status" column (and everything to the left of it) are from the SQL query.
Here's where the last row actually does include the formula correctly:
Here's where the last row actually does include the formula correctly:
