How to save a data file mutiple sheet togather without formulla

Hi Junaid,
Thank you for your reply. I think I understand what you are asking. You would like to keep the values in a worksheet, but not keep the links to other sources. Is that correct?

If so, there is a simple way to do this. Simply copy the entire worksheet (you can click on the grey box between column A and row 1), and then right click, choose Paste Special, then choose "Values." This will keep only the values in the cells, but will remove all formulas. Of course, if you decide you only want to keep values in some cells, and keep the formulas in others, copy only the individual cells where you want the values, and then paste special / paste values. You can then save your worksheet/workbook as normal.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer