I want my Excel file to go back to normal. I can't stop it from publishing
every time I save my file.

I would suspect that there is a "before save" macro somewhere in your
workbook that is sending a print command when you do a save. Check your
ThisWorkbook code module for the most obvious place. If not there, then I
don't know.

"Darkenmoor" wrote:

> I want my Excel file to go back to normal. I can't stop it from publishing
> every time I save my file.

All I know is when I saved the file as a web page, republishing was an option
given as a check box. Seems like there would be a place to turn it off. What
if I decided not to publish? Is microsoft really expecting me just to throw
the file away and start again? Somethings not right here.
Thanks! Any other ideas?
David

"JLGWhiz" wrote:

> I would suspect that there is a "before save" macro somewhere in your
> workbook that is sending a print command when you do a save. Check your
> ThisWorkbook code module for the most obvious place. If not there, then I
> don't know.
>
> "Darkenmoor" wrote:
>
> > I want my Excel file to go back to normal. I can't stop it from publishing
> > every time I save my file.

I have yet to find an off switch either; however, I do know of a work around.
Open the file in question, then start a brand new workbook. Copy everything
from the old work book into the new workbook. Close the old workbook (no need
to save). Then save the New Workbook as the Old one.

This will bring all data as well as database connections over and strip any
excess coding such as Print Formatting, Publishing, Column & Row sizes.

Then delete any published versions you don't want.

HTH,

Rich Webb

"Darkenmoor" wrote:

> All I know is when I saved the file as a web page, republishing was an option
> given as a check box. Seems like there would be a place to turn it off. What
> if I decided not to publish? Is microsoft really expecting me just to throw
> the file away and start again? Somethings not right here.
> Thanks! Any other ideas?
> David
>
> "JLGWhiz" wrote:
>
> > I would suspect that there is a "before save" macro somewhere in your
> > workbook that is sending a print command when you do a save. Check your
> > ThisWorkbook code module for the most obvious place. If not there, then I
> > don't know.
> >
> > "Darkenmoor" wrote:
> >
> > > I want my Excel file to go back to normal. I can't stop it from publishing
> > > every time I save my file.