Broken external links

slovenc0417

New Member
Joined
Sep 11, 2013
Messages
7
I have created a master time sheet workbook template that each individual in our office copies from a network folder on to their computer. The time sheet workbook references another master workbook containing client information that remains on the network and is edited by only one person. Basically within the time sheet work book I created a locked worksheet that re-creates a worksheet from the master workbook. From there, tabs are created for each month and in which the user enters a job number and the adjacent cells populate with client information, etc.

The problem is that the master time sheet work book is on the server. When a new user copies it from the server on to their computer, the link gets broken. What can be done to prevent the link from breaking and having to fix it?
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,223,900
Messages
6,175,276
Members
452,629
Latest member
SahilPolekar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top