I am changing the name of an EXCEL 2007 workbook ('A.xls' to 'AB.xls') and then changing its location to another FOLDER.
I then am creating another workbook with the original name ('A.xls) and PLACING it in the original folder.
Very simple and routine.

I have a desktop shortcut pointed to the 'A.xls'workbook in the original folder.
When the 1st or old wb is renamed and moved the shortcut continues to point to it even though the wb has been renamed.

It is a shared folder on a network drive. I can manually change the path within my shortcut so that it points to the new folder but how can I be sure that other users shortcuts are pointed to t he correct file (wb)?

Is there an easy command or setting to assure that the short cut will point to the correct file in the correct folder?

Thanks,
bjf44 - somewhat bewildered. Normally you should not do that. Why do you want to do that?
Perhasp if you could explain why this is a logical THING do do, there would be an explanation.
I mean to say, if you can explain the problem to other people so that it becomes very clear, then the solution will PRESENT itself.
As it is, you explanation sounds like something you are not supposed to do.

Wrong spot...i took the liberty of moving it.Re: moving an EXCEL file
After much thought I discovered the 'gotcha' that got me:

The old wb 'A.xls' was moved to the new location before it was renamed.
Apparently the shortcut path followed it.

When both the new and the old workbooks were renamed (FIRST) in the original folder before moving the old wb to a different location the integrity of the shortcut was maintained. The shortcuts path and file name was preserved.

Many thanks to all those who viewed this problem,

bjf44