I have several spreadsheets that are linked to one main spreadsheet, these spreadsheets are saved and a copy is created every month, how can I have the link to the main spreadsheet follow the new copies without manually creating another link to the new sheets?
Thanks 4 any help you can...
If no one else replies with a fit solution for you, then I would advise to rearrange your data.
Since you cannot save individual spreadsheets I am assuming that by spreadsheets you mean workbooks (excel files). Combine all you workbooks into one. Make a save of the entire workbook and rename it appropiately. You (or macro) could then delete all the unnecessary sheets from your workbook if desired.