Thread: Save as file as only text value

Hi
I have an excel file with several sheets linked to each other and even linked with another file. When I would 'Save it as' a different file I need only the values and not the links or formula. However, while I would just 'Save' the file it should keep the originality.

Can anybody help me with some code please?

Thanks

Pal

Before saving try to select all cells and paste special (in the same place) as values.

Adding to ExcelIsEasy's solution and since you has several sheets in your file I would recommend doing it with a macro.

Perhaps something like this:

Option Explicit

Sub Convert_toValue()

Dim i As Integer

For i = 1 To Sheets.Count

Sheets(i).Activate

With ActiveSheet

    .UsedRange.Copy
    
        .UsedRange.PasteSpecial Paste:=xlPasteValues
     
    Application.CutCopyMode = False
    
End With

Next i

End Sub

Alf