Overwrite instead of append on publish

K

KLEBESTIFT

I have a worksheet I publish as a webpage by going File -> Save as webpage,
selecting "Republish:sheet", and clicking on Publish and then Publish again
in the next dialong.

The problem I'm having is the report is being automatically appended to the
existing report (last week's data) and not overwriting it, which is what I
want to happen. I have used this same method before and been asked whether I
want to overwrite or append to the existing file, but excel doesn't ask me in
this case.

The only solution I've found is to delete the file manually and then
republish it, which is what I was trying to avoid by using republish.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top