Excel opens correct view - web (used frontpg) opens it wrong

J

Jim2003

I get excel all set up with a freeze pane showing about half the columns (
also just hid the unnecessary columns) and save it and when I open it - its
just like i saved it - Great!. Then I publish it in Frontpage and it opens
in preview or with IE on the web showing every column I hid. So when it
opens with excel or explore - Great - when it gets published it opens
differently exposing all the hidden columns. How do i fix this - big sheet
is not acceptable to client.

Jim2003
 
P

PokerZan

Try selecting the entire workbook and copy/pasting special (values),
then delete the rows you don't need then try to publish it. I don't
think that you can publish hidden rows via frontpage (may be wrong
though).

Oh, and don't forget to make a back up of your work prior to doing the
above... it could be bad if you don't. :cool:

If this is a workbook that needs to be updated on more than a
semi-regular basis (meaning, "needs to be live data"), I'm pretty sure
that Frontpage and Excal are not the long term answer here.

PS - Do you play poker?

PZan
 
Top