title: Macro Links Keep Changing
body: <p>We have a network drive &quot;\deg-da-01\Data&quot; that is being assigned to &quot;Z:&quot; drive. In my Excel Macro, I have an update instruction so the worksheet pulls data from a different worksheet in the network drive. Normally &quot;Z:...&quot; works, but occasionally it breaks and I have to change it to &quot;\deg-da-01\Data...&quot;. After a few days, &quot;\deg-da-01\Data...&quot; fails to work and then I have to change it back to &quot;Z:...&quot;. It seems that &quot;\deg-da-01\Data...&quot; and &quot;Z:...&quot; keeps switching back and forth. Is there a solution for that?</p>