Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Excel formats on the Web

I just discovered the 'amazing feature' of being able to convert entire
Excel documents to Web pages. ;-) Undoubtedly this will save me about a
hundred hours on a project I'm currently working on.

For the time being I have just one question though. When converting the
document all the formats I apply convert to the Web except the color of the
worksheet tabs.

Since the color of the tabs in my documents define groups or sections, it
would be nice to have this format carry through to the Web.

Any suggestions?

Also, if it can't be fixed during the initial conversion, can I edit it
after? Time consuming, yes, but better than doing the whole thing from
scratch.


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,365
Default Excel formats on the Web

I'm betting that even if you can edit the created file you won't want to -
generally the HTML generated by office apps is an absolute nightmare of
twisty little paths and little twisty paths. This is pretty much a WYSIWYG
situation. You might consider other visual indicators to identify groups and
sections, such as the manner in which you actually name the tabs, like

Grp1-Sheet1 | Grp1-Sheet2 | Section B-Sheet 44 ...etc

Keep in mind that you've only got 32 characters to use for sheet names.

"James E Middleton" wrote:

I just discovered the 'amazing feature' of being able to convert entire
Excel documents to Web pages. ;-) Undoubtedly this will save me about a
hundred hours on a project I'm currently working on.

For the time being I have just one question though. When converting the
document all the formats I apply convert to the Web except the color of the
worksheet tabs.

Since the color of the tabs in my documents define groups or sections, it
would be nice to have this format carry through to the Web.

Any suggestions?

Also, if it can't be fixed during the initial conversion, can I edit it
after? Time consuming, yes, but better than doing the whole thing from
scratch.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default Excel formats on the Web

Well don't get too used to the features, the same capabilities did not make
its way into the 2007 Excel or any other Office program for that matter.
--
William<"M"
Using 2007


"James E Middleton" wrote:

I just discovered the 'amazing feature' of being able to convert entire
Excel documents to Web pages. ;-) Undoubtedly this will save me about a
hundred hours on a project I'm currently working on.

For the time being I have just one question though. When converting the
document all the formats I apply convert to the Web except the color of the
worksheet tabs.

Since the color of the tabs in my documents define groups or sections, it
would be nice to have this format carry through to the Web.

Any suggestions?

Also, if it can't be fixed during the initial conversion, can I edit it
after? Time consuming, yes, but better than doing the whole thing from
scratch.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying formats - column widths, formats, outlining to worksheets DavidBr318 Excel Worksheet Functions 4 August 14th 09 05:03 AM
Excel Date Formats Teethless mama Excel Discussion (Misc queries) 0 February 15th 07 03:04 PM
Time formats in Excel Office Gopher Excel Discussion (Misc queries) 3 August 24th 06 05:30 PM
Excel cell formats sboyland Excel Discussion (Misc queries) 2 April 20th 05 05:05 PM
Excel conditional formats Eric Hudson Excel Discussion (Misc queries) 4 March 6th 05 05:15 AM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"