To remove the formulas from excel sheet you can go to Data menu, and you will find Workbook Links. Click here and a window showed up. Click Break All and Break Links. One condition is that the source and destination data should be in different workbooks. Please watch the full video to understand the procedures.
Please like and subscribe and don’t forget to hit the bell icon.

Link Break,paste special,This workbook contains links to one or more external sources that could be unsafe,excel,workbook link,beak link,microsoft,2013,2010,2016,office,If you trust the links,update them to get the latest data. Otherwise,you can keep working with the data you have,Excel 2016,Excel 2013,Excel 2019,excel external links,edit external links in excel,excel find external links,no vba,excel formula to get links,Excel LINKS,Excel FILES,Excel dynamic arrays,excel magic formula,excel hacks,excel tricks,get list of files in folder,microsoft excel for beginners,

Other Related Videos You May Watch:
https://youtube.com/shorts/2TfWR1mDGIk?feature=share
https://youtube.com/shorts/-VgcNUVzt3g?feature=share
https://youtube.com/shorts/JdP4OwZDV78
https://youtube.com/shorts/G_1emA4Z11A?feature=share
https://youtube.com/shorts/gc-kLPIbNtE?feature=share
https://youtube.com/shorts/CR2l7G25nBA?feature=share
https://youtube.com/shorts/jrcyvZZE4co?feature=share

Links
Facebook Link : https://www.facebook.com/excelsolutionsbasicandadvanced/
Facebook Group : https://www.facebook.com/groups/416865405424675/
Blog : http://advanced-excel-solved.blogspot.com/

#excel #pastespecial #pivottable/

Please take the opportunity to connect and share this video with your friends and family if you find it useful.