close

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.

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

    software

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