How to select Excel autorepublish as HTML location ?

[bsobaid]

Hi,

I have an Excel sheet that I save as webpage and auto republish the
workbook every time it is saved.
The problem is that even when I change the location of "save as
webpage", it does'nt stop saving it as webpage at its previous
location.

For example,

I did a "save as" webpage on "C:/location_AA/mysheet.htm", clicked
"Publish" and selected the "auto republish every time it is saved"
option.

It works fine and it republishes the html at its proper location.

Now, I dont want excel to autorepublish it to the location I selected
earlier i-e "C:/Location_A/mysheet.htm"

I want excel to autorepublish it to another location at
"C:/location_BB/mysheet.htm"
So I repeat the process and do "save as webpage", click "Publish" and
select the auto republish option.

What happens is that excel now starts republishing it to both
locations.
"C:/location_BB/mysheet.htm"
as well as
"C:/location_AA/mysheet.htm"


How can I stop Excel to stop republishing the sheet to the older
location ??

Thanks,

 

[bsobaid]

One more thing, I am using Excel 2003