close

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
quot;publicquot; 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 quot;privatequot; 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.

quot;Bob in COquot; wrote:

gt; I need to place my excel tracking sheet (names, dates, prices) on a public
gt; area on our company intranet for employees to view (view only). I would
gt; prefer to keep the excel workbook on my drive, and have updates go to the
gt; quot;publicquot; version of the table. Maybe I could even have a few more columns on
gt; my private (original) version.
gt;
gt; It need to be pretty simple, as I don't want to spend much time and tech
gt; support is minimal
gt;
gt; 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 quot;original.

Thanks again
Bob in CO

quot;JLathamquot; wrote:

gt; Have you thought about creating a sheet in your workbook to show just the
gt; information you want to be viewed and saving it as .html (using File | Save
gt; As) and then pushing the created .html file out to your intranet?
gt;
gt; The reason I suggest creating a separate sheet is so that you can have those
gt; extra columns in your quot;privatequot; version - which would be a separate sheet in
gt; your workbook. As long as you have easy ability to move the page into your
gt; intranet space this is a pretty simple solution.
gt;
gt; quot;Bob in COquot; wrote:
gt;
gt; gt; I need to place my excel tracking sheet (names, dates, prices) on a public
gt; gt; area on our company intranet for employees to view (view only). I would
gt; gt; prefer to keep the excel workbook on my drive, and have updates go to the
gt; gt; quot;publicquot; version of the table. Maybe I could even have a few more columns on
gt; gt; my private (original) version.
gt; gt;
gt; gt; It need to be pretty simple, as I don't want to spend much time and tech
gt; gt; support is minimal
gt; gt;
gt; gt; 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. quot;Validation Load Error: Type List, Absense of a Range etc...quot; Do you
know what this error means?
--
Thank you for your time.
quot;Happiness is not having what you want, but wanting what you havequot;quot;JLathamquot; wrote:

gt; Have you thought about creating a sheet in your workbook to show just the
gt; information you want to be viewed and saving it as .html (using File | Save
gt; As) and then pushing the created .html file out to your intranet?
gt;
gt; The reason I suggest creating a separate sheet is so that you can have those
gt; extra columns in your quot;privatequot; version - which would be a separate sheet in
gt; your workbook. As long as you have easy ability to move the page into your
gt; intranet space this is a pretty simple solution.
gt;
gt; quot;Bob in COquot; wrote:
gt;
gt; gt; I need to place my excel tracking sheet (names, dates, prices) on a public
gt; gt; area on our company intranet for employees to view (view only). I would
gt; gt; prefer to keep the excel workbook on my drive, and have updates go to the
gt; gt; quot;publicquot; version of the table. Maybe I could even have a few more columns on
gt; gt; my private (original) version.
gt; gt;
gt; gt; It need to be pretty simple, as I don't want to spend much time and tech
gt; gt; support is minimal
gt; gt;
gt; gt; Bob in CO

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()