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.

"Bob in CO" wrote:

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

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

"JLatham" wrote:

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.

"Bob in CO" wrote:

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

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?
--
Thank you for your time.
"Happiness is not having what you want, but wanting what you have"


"JLatham" wrote:

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.

"Bob in CO" wrote:

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