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
- Sep 10 Mon 2007 20:39
Postging Excel Table on Intranet
close
全站熱搜
留言列表
發表留言