I have a project plan with 3 supporting worksheets. I want to launch the supporting worksheet FORM within my project plan. So, I copied the supporting sheets FORM URL into the attachment cell on the appropriate row for each corresponding support sheet. So far, so good.
Then, I did a "Save As" using the option to have all links go to the new sheets. But, on the copied version, when using the URL link within the project for the supporting sheet's FORM, the data goes back to the original supporting sheet and not the new supporting sheet. However, if I use the form directly from that supporting sheet, it collects the data in the new sheet.
It appears the URL is not being updated if it is a link to a form. Any ideas?