Excel 2010 Export as HTML

I'm trying to export my Excel document to an HTML file. Everything is fine and dandy, except the cells that I have hidden are now showing up in the HTML file when I open it up. Any ideas?
LVL 13
IT_CrowdAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

etech0Commented:
I think that would make sense. HTML doesn't know about hiding rows. Maybe you want to delete the hidden cells before exporting?
0
IT_CrowdAuthor Commented:
:(  unfortunately, I am using some of the columns/cells in formulas and deleting them would break the formulas.
0
etech0Commented:
In that case you might want to select the whole sheet, copy, and paste values.
Unless you want the formulas (as opposed to the results) to come through in your HTML.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

IT_CrowdAuthor Commented:
I agree with you, and thats what I tried, but it doesnt look like the hyperlink formula will paste correctly - the link is broken.

I'll upload the excel file in question here so it might make more sense.  
AdminRecord.xlsx
0
etech0Commented:
No problem
0
etech0Commented:
Okay. Instead of the formula you currently have in column B, put this:
<a href="1984-11-08;DOC;;;DOE Old Wade House.pdf">0000000001</a>

Another thing is that you will have to include somewhere, either in the forumla or in column A, the full file path to where these files are stored, or the html file will not know where to look to find them, and the links won't work.
0
IT_CrowdAuthor Commented:
Thanks for the ideas.

We're currently working on the following possibility: moving the "hidden" columns to sheet 2, creating the HTML file, and then telling the HTML file to hide sheet 2.

Will report back.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
etech0Commented:
Smart!
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Instead I would copy all visible columns to a new or empty sheet,
Or just add references to the visible cells in another sheet, and show that sheet in HTML.
0
IT_CrowdAuthor Commented:
We ended up using the "move hidden columns to sheet 2" ideas, but etech0's post is also relevant and could have been used to resolve the issue we were having.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.