Where data is linked to another underlying file, we can break the link to return a hardcoded value instead. We do this by selecting “Break Links” in “Edit Links” in the data tab.

Instagram: https://www.instagram.com/ms_excel_skills/

 #exceltips #officeskills #data #dataanalytics #irishbizparty #text #excelskill #microsoft #pivot

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