If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Instead of a negative number, I'd like to show zero... | Dr. Darrell | Worksheet Functions | 6 | December 7th, 2005 08:21 PM |
Linked cell displays 0 | AMY Z. | Worksheet Functions | 2 | December 6th, 2005 07:56 PM |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
Formulas employing cells linked to a combo box drop list | Frank Kabel | Worksheet Functions | 3 | May 27th, 2004 04:44 PM |
Convert a Cell Reference to Text | Chuck Buker | Worksheet Functions | 6 | September 22nd, 2003 05:04 PM |