Easy question - copying worksheet and keeping formulas

V

vj1031

Sorry I am a begginenr- I have a worksheet that has formulas. When I try to
copy this worksheet into a tab on another worksheet the values are copied but
not the formulas. What am I doing incorrectly?
 
S

Sheeloo

Formulae do get copied when you copy a worksheet.

Can you describe the steps you perform?

Try this
Right-click on the worksheet tab, choose Move or Copy and make your choices
(Click on create a Copy).

Formulae should also be copied to the new sheet.
 
G

Gord Dibben

Do you have each workbook running in a separate instance of Excel?

If so, close one instance and open both workbooks in a single instance.


Gord Dibben MS Excel MVP
 

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

Array 3
Embed the same Excel multiple times 0
sumproduct with COUNTIF With An INDIRECT 1
problems getting this macro to work 8
Auto deletion of cell entry in given circumstance 0
Copy addition formula of non-consecutive horizontal cells 2
Help please with cut paste and formulas 4
Autonumber field in Excel that behaves the same as Access 0

Top