Junaid has attended:
Excel Advanced course
How to save a data file mutiple sheet togather without formulla
how to save a data file multiple sheet together without formula just values in excel
RE: how to save a data file mutiple sheet togather without formu
Hello Junaid,
I hope you enjoyed your Excel training session with us.
In response to your question, I'm not sure I quite understand exactly what you are asking. Can you elaborate what is it you are looking to do?
Regards,
Mara
Microsoft Office Specialist Master Trainer
RE: how to save a data file mutiple sheet togather without formu
Hi Mara
What i meant in my question is how to save a file which has a multiple excel sheet all linked and have data through advance formula's. I want to save save this file with all the data but no formula. i mean is there a way to save the whole file as values in which the file format remain the same.
Regards
Junaid
RE: how to save a data file mutiple sheet togather without formu
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
