Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Locking a table
Hello,
I am using excel 2003 and have created a small table, 4 colums wide by 5 rows. I have inserted this table as an object into a Microsoft word 2003 document. When I double click this table in Word I have excel functionality, unfortunately, it also means that a user can scroll around the table and take it out of view. I have hidden the column headers and scroll bars. Is there a way that this table can be locked so that a user can only see the 4x5 table? Thanks in advance. Ket London. |
#2
|
|||
|
|||
Instead of inserting as an object, copy the relevant cells then paste
special into Word. You can opt to keep the table linked to the original so any change in the original will be reflected, or to break the link for static data. -- Ian -- "Ket" wrote in message ... Hello, I am using excel 2003 and have created a small table, 4 colums wide by 5 rows. I have inserted this table as an object into a Microsoft word 2003 document. When I double click this table in Word I have excel functionality, unfortunately, it also means that a user can scroll around the table and take it out of view. I have hidden the column headers and scroll bars. Is there a way that this table can be locked so that a user can only see the 4x5 table? Thanks in advance. Ket London. |
#3
|
|||
|
|||
Ian,
Thanks for this. What I should have mentiond also is that the user will need to open the embedded excel table and change 3 cell values before coming out. The idea of a linked image file is a good one if it wasn't for this. Still greatful for any input - Thanks! On Wed, 14 Sep 2005 18:25:58 GMT, "Ian" wrote: Instead of inserting as an object, copy the relevant cells then paste special into Word. You can opt to keep the table linked to the original so any change in the original will be reflected, or to break the link for static data. -- Ian |
#4
|
|||
|
|||
I can't offer any other suggestions. Sorry.
-- Ian -- "Ket" wrote in message ... Ian, Thanks for this. What I should have mentiond also is that the user will need to open the embedded excel table and change 3 cell values before coming out. The idea of a linked image file is a good one if it wasn't for this. Still greatful for any input - Thanks! On Wed, 14 Sep 2005 18:25:58 GMT, "Ian" wrote: Instead of inserting as an object, copy the relevant cells then paste special into Word. You can opt to keep the table linked to the original so any change in the original will be reflected, or to break the link for static data. -- Ian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Data In Pivot Table | New Users to Excel | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
table | Excel Discussion (Misc queries) | |||
table | Excel Worksheet Functions |