View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Chockku
 
Posts: n/a
Default A Cell linked between 2ExcelFiles, changes not seen in IE(inweb)


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 & B. if any
changes have done in the A.xls in C17 cell then the B.xls C17 will have the
same data & Vice Versa. Its working fine in the server when i try. I created
a webpage & given a link to open this file. When the user made some changes ,
some times its affected in both A.xls & 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.