Changing And Updating Links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have about 60 - 80 columns on a monthly worksheet that needs to have the data source changed every month. Is there a method for doing this, other than the Edit's menu sub menu Links way of doing this. I reference about 19 cell's vertically on a particular sheet within 60-80 work books. I end up having to do this manually every month.

If there is a easier way, I'd appreciate hearing for anyone who has face a similar situation. I have attempted the record macro appraoch to no avail due to the security level used on the network system where the source data sits.

I'm open to suggestions......

Thanks,
 
If the worksheet names stay the same from month to month, then you can place a copy of each spreadsheet in a particular subdirectory and link to that copy. Then every month copy the new worksheets in their place.

If they change every month, the problem is a bit trickier. You might have to create a macro to do the job for you.
 
Back
Top