Excel links keep crashing

0 votes
Excel crashes a lot on my mom's slow computer. All 100 of the links in her sheet are broken when it crashes since they are all changed to the roaming folder. One master sheet on her computer links to one hundred separate workbooks. The documents are numbered 1 through 100. And I need to manually alter each link to go to the already-existing folder. I want to link the macro to a button for her when this occurs, therefore is there a method to do this with VBA. The same folder always houses all of the workbooks.

I've done a lot of searching on Google but haven't been able to discover anything that is even close to what I require. So, this is all new.
Jan 30, 2023 in Others by Kithuzzz
• 38,020 points
566 views

1 answer to this question.

0 votes

When the links in the master sheet break, you can create a VBA macro to change the links back to the current folder.

Sub UpdateLinks()
    Dim wb As Workbook
    Set wb = ThisWorkbook

    Dim lnk As Variant
    For Each lnk In wb.LinkSources(xlExcelLinks)
        wb.ChangeLink Name:=lnk, NewName:=Replace(lnk, "Roaming", "Existing")
    Next lnk

End Sub
answered Jan 30, 2023 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
0 answers

What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,020 points
333 views
0 votes
1 answer

How to merge columns in Excel but keep data on other columns

VLOOKUP indeed can be used here, combined ...READ MORE

answered Nov 19, 2022 in Others by narikkadan
• 63,720 points
908 views
0 votes
1 answer

Rails - Export records to downloadable excel file using axlsx gem (Keep MVC)

Use  axlsx_rails Gem with the template. In my case, ...READ MORE

answered Nov 19, 2022 in Others by narikkadan
• 63,720 points
2,106 views
0 votes
1 answer

How to keep one variable constant with other one changing with row in excel

Use this form: =(B0+4)/$A$0 Since you are dragging across ...READ MORE

answered Nov 24, 2022 in Others by narikkadan
• 63,720 points
474 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,690 points
931 views
0 votes
1 answer

Remove formulas from all worksheets in Excel using VBA

Try this : Option Explicit Sub test1() ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,720 points
1,929 views
0 votes
1 answer

Calculate monthly average from daily data without PivotTable

Assuming you have the months in column D enter ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,720 points
1,687 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

answered Oct 7, 2022 in Others by narikkadan
• 63,720 points
1,233 views
0 votes
1 answer

How can I convert excel to PDF by Libreoffice and keep all format from excel file?

"Times New Roman" typeface does not have ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,720 points
1,596 views
0 votes
1 answer

Excel create an Index on the first sheet with links to subsequent sheets

This seems to be a potential duplicate ...READ MORE

answered Oct 22, 2022 in Others by narikkadan
• 63,720 points
1,290 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP