Forum Discussion
Solved
How to save copies of individual sheets from a workbook, separately from the workbook or ... ?
Hi!! I created a workbook with four sheets: "PatientDataset" "FeeDataset" "Chart Note" (pulls info from the "dataset" sheets) "Charge Slip" (pulls info from the "Chart Note" sheet) The...
- I would recommend you just print the sheet to PDF that will 'lock' everything.
If you need/want to keep the excel sheet format then you can right click the tab and select Move or Copy and then under the move copy window select the copy option box and in the drop down select new workbook. After you copy the sheet to a new workbook, goto Data and edit links and then remove all links to other workbooks, that should prevent it from updating any info based on changes in the other workbook
I would recommend you just print the sheet to PDF that will 'lock' everything.
If you need/want to keep the excel sheet format then you can right click the tab and select Move or Copy and then under the move copy window select the copy option box and in the drop down select new workbook. After you copy the sheet to a new workbook, goto Data and edit links and then remove all links to other workbooks, that should prevent it from updating any info based on changes in the other workbook
If you need/want to keep the excel sheet format then you can right click the tab and select Move or Copy and then under the move copy window select the copy option box and in the drop down select new workbook. After you copy the sheet to a new workbook, goto Data and edit links and then remove all links to other workbooks, that should prevent it from updating any info based on changes in the other workbook
- Hi! Oh my gosh, thank you so much! I feel like "duh!", lol. Thank you! The PDF option will work perfectly. Have a wonderful day!! Diane
