Postging Excel Table on Intranet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to place my excel tracking sheet (names, dates, prices) on a public
area on our company intranet for employees to view (view only). I would
prefer to keep the excel workbook on my drive, and have updates go to the
"public" version of the table. Maybe I could even have a few more columns on
my private (original) version.

It need to be pretty simple, as I don't want to spend much time and tech
support is minimal

Bob in CO
 
Have you thought about creating a sheet in your workbook to show just the
information you want to be viewed and saving it as .html (using File | Save
As) and then pushing the created .html file out to your intranet?

The reason I suggest creating a separate sheet is so that you can have those
extra columns in your "private" version - which would be a separate sheet in
your workbook. As long as you have easy ability to move the page into your
intranet space this is a pretty simple solution.
 
I appreciate the response, I played with that a bit today. I might do
something like that. I would have to save local and then as html to the
intranet as well.

The only downside is my department has no real presence on the intranet,
just a folder. But it could be a link in the folder.

I have to explain how to people who can hardly use a computer. I really
wanted to set it up to just be a mirror image out there that updated
regularly, and like a mirror image it you can't be changed from the "original.

Thanks again
Bob in CO
 
Mr. Latham,

Could you explain this process you suggested a bit more. I have the same
need as the original poster. I followed your directions and received and XML
error. "Validation Load Error: Type List, Absense of a Range etc..." Do you
know what this error means?
 
Back
Top