Table Not Copying Formulas

excelbytes

Board Regular
Joined
Dec 11, 2014
Messages
245
Office Version
  1. 365
Platform
  1. Windows
I wrote VBA code to create a report for a client. It creates a table and in several columns enters formulas in the top cell of several columns. Until yesterday, when the code entered the formulas, the table would automatically copy the formulas down as a table is supposed to. Suddenly, it stopped automatically copying the formulas down. Any idea how something like this can happen? Is there a setting for this? The code did not change. Any thoughts?
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
It means that somewhere along the line the Table has inconsistent formulas and stopped replicating the rows.
  • Make sure no filters are applied.
  • Pick any cell with correct formula > Ctrl+C
  • Highlight all the rows in the column including the one you are coping from and hit Ctrl+V
    (you can use Ctrl+Space to highlight all the rows)
    Note: Do not highlight the whole column of the worksheet, only the rows in the table
Once you have done this try and add a row and see if the formula replicates down because it should be fixed now.
 
Upvote 0
Other possible options
1) The sheet is protected.
2) Under options, Proofing, AutoCorrect Options, Auto Format as you type, make sure the last two check boxes are ticked.
 
Upvote 0
Solution
Glad we could help & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,553
Messages
6,114,279
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top