Linked worksheets

  • Thread starter Thread starter JHaberstock
  • Start date Start date
J

JHaberstock

I have a worksheet for inventory that has the item and the cost. We link po's
to this worksheet so that when we open them the amounts fill in. Our problem
is once the po is completed we do not want the numbers to update if it should
be reopened after changes are made to the first worksheet. Is there a way to
prevent this from happening. We have tried to change the update to manual,
but the program will not allow us to do this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Linking 2 documents 2
Another Join/Merge Question 2
Lookup and return next value 1
Reconciliation of Data With Two Conditions 2
Excel Referencing one cell from a different worksheet and slide in powerpoint 0
Can I compare two worksheets using Excel? 5

Back
Top