Does anyone have a solution for dynamic tables that have formulas built into them not automatically calculating values when dragged down, but will calculate when doing a flash fill or individually being dragged down? I have double checked the Calculation Options setting and it is set to Automatic and also checked the Options>Proofing>Autocorrect to automatically calculate table formulas, but am still having the same problem. I am running Excel 2016 on a Dell Laptop.
Are the formulas there and not calculating, or do the formulas not appear at all?
Tables are great for replicating formulas, formats, validations as new rows of data are added. However, they only do so when the information is the same in each of the rows above it. So if you have a formula in column K, for example, it will replicate for each row until you break the succession. If you typed in data manually over a formula in column K then the string is "broken" and the formula will not replicate down automatically.
If you want formulas all the way down, pick a cell with the desired formula and copy it to each row in the existing table. Then new rows should start replicating the formula again.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks