Hello All,
I have been using Excel auto-publushing (as html) feature successfully for the last number of years to maintain and internal reporting system via a basic HTML website. I have migrated the from Exel 2000 through 2007 success fully in the past and yesterday I migrated to excel 2010. Now however, the "Auto republish every time this workbook is saved" feature no longer publishes the workbooks I maintain to HTML. The only way I have been able to publish is to maually go into the workbook, select " Publish as web page" (removed from the standard ribbon) and click publish. Even though the "Auto republish every time this workbook is saved" tickbox is filled the file will not publish when a macro saves the file. I can find no info on any forum about this issue, so i think i am risking great shame by admitting that I may have over looked something very simple, but i cannot figure this out.
I have searched the "Option" section in excel 2010 and can find no restriction in relation to publishing. Has anyone else experiencied this? If so i would like some advice.
Excel 2010 (GRRRRR)
OS: Win XP (soon to be win 7)
I have been using Excel auto-publushing (as html) feature successfully for the last number of years to maintain and internal reporting system via a basic HTML website. I have migrated the from Exel 2000 through 2007 success fully in the past and yesterday I migrated to excel 2010. Now however, the "Auto republish every time this workbook is saved" feature no longer publishes the workbooks I maintain to HTML. The only way I have been able to publish is to maually go into the workbook, select " Publish as web page" (removed from the standard ribbon) and click publish. Even though the "Auto republish every time this workbook is saved" tickbox is filled the file will not publish when a macro saves the file. I can find no info on any forum about this issue, so i think i am risking great shame by admitting that I may have over looked something very simple, but i cannot figure this out.
I have searched the "Option" section in excel 2010 and can find no restriction in relation to publishing. Has anyone else experiencied this? If so i would like some advice.
Excel 2010 (GRRRRR)
OS: Win XP (soon to be win 7)