Special Pasting a work book with many sheets and formulas

L

lex63

I have a workbook with many sheets that all have formulas and links to other
data. I want to save the workbook as another name with all the worksheets
keeping the values only (no links or formulas). Is there a quick way to do
this for everysheet without having to special paste every sheet in the
workbook. So can I save everysheets data values at workbook level.
 
L

Luke M

Under Edit - Links, you can break links can cause the formulas to become
static values.
 

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

problems getting this macro to work 8
Paste Special Values 2
REMOVING WORKBOOK'S ALL FORMULAS 3
Paste Values in linked Cells Only 4
Custom toolbar button for search and replace 1
REMOVING FORMULAS 2
Pasting formulas 4
File size too big 1

Top