copying formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when copying a formula from one cell using the cell drag down method to the
cell below I get the value of the first cell. I have tried using the paste
special function and following the general tips with no success. I have
tried the method on another computer and it works, could there be something
in the worksheet that needs to be changed
 
It could be just the calc mode, inadvertently set to manual. Click Tools >
Options > Calculation tab. Options are there. Ensure it's set to Automatic >
OK.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
drag formula down from columns that go acros 3
copying formulae 5
using the =page! feature to transpose a row to column 0
how copy formula that contains ranges so ranges do not overlap 1
want to track time while paste value in multiple column of same roe 1
Paste Special Multiply Formulas not working in Excel 2007 1
Copying formulas from one cell to another 7

Back
Top