Hi,
I have 2 Excel files in Server. C17 is the Cell No. in Both the sheets are
linked. (i.e) for example i have the 2 excel files named A amp; B. if any
changes have done in the A.xls in C17 cell then the B.xls C17 will have the
same data amp; Vice Versa. Its working fine in the server when i try. I created
a webpage amp; given a link to open this file. When the user made some changes ,
some times its affected in both A.xls amp; B.xls and some times it is not
affected. Even thought the sheet was saved.
How to refersh the excel sheet which displayed in the web page or is there
any way to refers the Excel file in a regular interval. Kinldy suggest me how
to solve this
problem.
Thankyou,
Chock.
In your edit menu click on quot;links...quot; In this window you should have the
option to update your links. That should do the trick!
quot;Chockkuquot; wrote:
gt;
gt; Hi,
gt;
gt; I have 2 Excel files in Server. C17 is the Cell No. in Both the sheets are
gt; linked. (i.e) for example i have the 2 excel files named A amp; B. if any
gt; changes have done in the A.xls in C17 cell then the B.xls C17 will have the
gt; same data amp; Vice Versa. Its working fine in the server when i try. I created
gt; a webpage amp; given a link to open this file. When the user made some changes ,
gt; some times its affected in both A.xls amp; B.xls and some times it is not
gt; affected. Even thought the sheet was saved.
gt;
gt; How to refersh the excel sheet which displayed in the web page or is there
gt; any way to refers the Excel file in a regular interval. Kinldy suggest me how
gt; to solve this
gt; problem.
gt;
gt; Thankyou,
gt; Chock.
- Jul 16 Mon 2007 20:38
A Cell linked between 2ExcelFiles, changes not seen in IE(inweb)
close
全站熱搜
留言列表
發表留言