How do I save an Excel workbook so that cells referencing another.
I know we can copy and paste special so that cells referencing other
workbooks are changed to values-only but wonder if there's a way to simply save a multi-sheet, complex workbook that references many other workbooks as values. This would be ideal for sending out up-to-date reports so that my recipients aren't bothered with the "workbook contains values linked to another workbook" pop-up. Any suggestions? |
You could run a little macro to convert to values.
But don't forget to save this as a new name--it might bring tears if you save over your workbook that contains the formulas! Option Explicit Sub testme() Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets With wks.UsedRange .Copy .PasteSpecial Paste:=xlPasteValues End With Next wks 'save it as a new name!!! Application.Dialogs(xlDialogSaveAs).Show End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm williejoeshaver wrote: I know we can copy and paste special so that cells referencing other workbooks are changed to values-only but wonder if there's a way to simply save a multi-sheet, complex workbook that references many other workbooks as values. This would be ideal for sending out up-to-date reports so that my recipients aren't bothered with the "workbook contains values linked to another workbook" pop-up. Any suggestions? -- Dave Peterson |
All times are GMT +1. The time now is 06:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com