Template with Multiple Worksheets

[mchase]

Hi,

I've created a template with multiple sheets (Estimate Template with sheets for original take off, proposal, invoices, and expense tracking) that I've sent out to all of my project managers and estimators within my company. The 'Take Off' sheet feeds all the other sheets in the file.

When they open it up on thier computers, all of the links are linking back to my original template (on my hard drive) and fails to work. Also, I have attached a jpg into the header of most pages of our company logo and the same problem happens with the logo (original jpg is on my hard drive).

How can I fix this?

 

[Datsmart]

Setup your links to files your employees have access to. Like a shared drive instead of your hard drive.

 

[mchase]

all my links are contained within the document (except for the jpg image). they reference different sheets within the same document.

but when they open the template (or click New... and open a copy of the template) instead of referencing sheets within the newly created copy of the template, it looks for the original template sheet reference.