Excel File backup

  • Thread starter Thread starter Rajkumar
  • Start date Start date
R

Rajkumar

Hi everyone,

I have a excel file with 8 sheets & i would like to have a backup fil
for this with values alone in it.something like paste special values i
the backup file.

Regards,
Rajkuma
 
Why values only? - does this file have lots of links to external files? - Do you
care about internal links within the file.

You could try saving a copy down as a backup and then do Edit / Links / Break
Links to break all ties to the external files (Depending on your version).
 
If you want to convert all the formulas on all the worksheets to values, you
can:

Save your workbook as a new name--you don't want to ruin the original!

Rightclick on a worksheet tab
select All sheets
hit ctrl-A (to select all the cells) (ctrl-A twice with xl2003).
Edit|copy
Edit|paste special|Values
Select A1

Right click on a worksheet and select Ungroup Sheets

Save that workbook once more.
 
Back
Top