Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
A Cell linked between 2ExcelFiles, changes not seen in IE(inweb)
In your edit menu click on "links..." In this window you should have the
option to update your links. That should do the trick! "Chockku" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Cell Validation List & Linked Cell VLOOKUP | Excel Discussion (Misc queries) | |||
Fill colour a cell from the linked cell | Excel Discussion (Misc queries) | |||
Making path of linked cell dynamic | Excel Discussion (Misc queries) | |||
Copying linked cell references. | Excel Worksheet Functions | |||
Linked cell location of hyperlink | Excel Worksheet Functions |