Sorry but still not possible. I wish MS would enable this feature. Sheets with loads of references to e.g. underlaying forrest of sheets cannot be moved without loads of work to manually change the links.

> On Tuesday, November 02, 2010 9:29 AM David wrote:

> Hi, I hope somebody can help. I have an application that has been
> built in WSS, at point in the use of the application a new site is
> created, within that site I have a template (Excel) sitting in a
> document library. I can open the Excel workbook from within the site
> and record a macro that saves that excel workbook back into the
> document library where the excel workbook was opened from as a .csv
> file, all good so far. The macro includes and absolute path to where
> the .csv file should be created and therefore if I run the macro from
> an Excel workbook that resides in a different site it attempts to
> place the .csv in that absolute path, the one that was referenced when
> creating the macro and not the one where the workbook is now being
> opend from and where the .csv extract needs to go. I need to modify
> the macro so that it creates / saves the .csv in the location from
> which the excel workbook was opened, regardless of where it is
> sitting. So currently the path where it saves (copied from the
> recorded macro) is as follows;
> 
> "http://redtree01:90/Products/7/Product Plans/Product
> Rollout.csv",
> 
> I need to change it to "http://redtree01:90/location where the
> currently open workbook resides/Product Rollout.csv",
> 
> As may be obvious I have no previous experience in this, the answer, I
> am assuming, is a simple one?