PC Review


Reply
Thread Tools Rate Thread

Auto Publishing

 
 
anshuman
Guest
Posts: n/a
 
      14th Aug 2008
Hi All,

I have an excel file which is linked to my web page and it is auto
published.


However, now I need to send a copy of the file to a friend but I am
afraid that any copies made from the source file will also try to
publish to the web page. I do not want this to happen...


Any idea on how to stop auto publishing in microsoft excel or make a
copy of the file without the auto publishing feature?


Thanks in advance,


Anshuman

 
Reply With Quote
 
 
 
 
Gary Brown
Guest
Posts: n/a
 
      14th Aug 2008
From the top menu (assuming Excel 2003 and lower), select...
FILE then SAVE AS WEB PAGE then PUBLISH
In the 'Publish as' section, uncheck 'AutoRepublish every time this workbook
is saved.'
As an extra precaution, In the 'Publish as' section,, change the 'Filename'
to something like 'C:\Temp\Do_not_publish.xls'
Select PUBLISH.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"anshuman" wrote:

> Hi All,
>
> I have an excel file which is linked to my web page and it is auto
> published.
>
>
> However, now I need to send a copy of the file to a friend but I am
> afraid that any copies made from the source file will also try to
> publish to the web page. I do not want this to happen...
>
>
> Any idea on how to stop auto publishing in microsoft excel or make a
> copy of the file without the auto publishing feature?
>
>
> Thanks in advance,
>
>
> Anshuman
>
>

 
Reply With Quote
 
anshuman
Guest
Posts: n/a
 
      15th Aug 2008
Thanks for the response.

However, I have 100+ objects from the file which are getting published
to the sharepoint at various places on multiple dashboards. So, I
guess i need to uncheck the auto-publish option for all the charts,
and dhasboards one by one.

I found another method this morning.

I selected all the tabs of the file and made a copy to a new workbook.
When I saved the new workbook, the auto-publish option did not come
with it.

Earlier, I was trying to copy the file itself and the auto publish
option was also coming along.

Thanks for the help however.


On Aug 14, 9:13*pm, Gary Brown <gary.brown.deletethisp...@stmh.org>
wrote:
> From the top menu (assuming Excel 2003 and lower), select...
> FILE then SAVE AS WEB PAGE then PUBLISH
> In the 'Publish as' section, uncheck 'AutoRepublish every time this workbook
> is saved.'
> As an extra precaution, In the 'Publish as' section,, change the 'Filename'
> to something like 'C:\Temp\Do_not_publish.xls'
> Select PUBLISH.
> --
> Hope this helps. *
> Thanks in advance for your feedback.
> Gary Brown
>
> "anshuman" wrote:
> > Hi All,

>
> > I have an excel file which is linked to my web page and it is auto
> > published.

>
> > However, now I need to send a copy of the file to a friend but I am
> > afraid that any copies made from the source file will also try to
> > publish to the web page. I do not want this to happen...

>
> > Any idea on how to stop auto publishing in microsoft excel or make a
> > copy of the file without the auto publishing feature?

>
> > Thanks in advance,

>
> > Anshuman


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Publishing anshuman Microsoft Excel Misc 0 21st Jul 2008 09:44 AM
Auto resize, auto realign, auto ANYTHING driving me crazy spasmous@yahoo.com Microsoft Powerpoint 2 30th Apr 2005 02:14 AM
Auto-Publishing form with script, cmdbtn won't function Bob S Microsoft Outlook Form Programming 3 29th Apr 2004 01:11 PM
How do I stop a spreadsheet from Auto-publishing as a web page? CJM Microsoft Excel Misc 0 26th Feb 2004 03:50 PM
Publishing problems--changed files not publishing Mark Microsoft Frontpage 8 8th Dec 2003 02:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:02 AM.