We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Workbook Name References

Thread ID:





120962 Oct 29,2015 03:33 PM UTC Nov 3,2015 05:06 AM UTC WPF 3
Tags: XlsIO
Calvin Schrotenboer
Asked On October 29, 2015 03:33 PM UTC

In simplified form, I have an Excel template file which consists of two worksheets.  If I put a value in the second worksheet which reads "=+Worksheet1!C10" I would like the cell on the second worksheet to display the same value as appears on Worksheet 1 in cell C10.  Unfortunately, however, when a new spreadsheet based on the two template worksheets is opened, my referencing cell, instead of showing the value that I want, displays an error. 

However, if I put the cursor in the status (data entry) textbox at the top of the worksheet and hit the enter key, this reference is resolved and the correct value is displayed.  

In reality, my template file contains many worksheets and I have many, many cross referenced cells which I would like to have automatically resolved/updated when the spreadsheet is opened. Expecting users to manually update these references is not a practical option.  Is there any way to achieve this programmatically?


Ishwarya Narayanan [Syncfusion]
Replied On October 30, 2015 10:05 AM UTC

Hi Calvin,


Thank you for contacting Syncfusion support.


We are unable reproduce the issue, so we have prepared a simple sample as per your scenario in the below link. Kindly modify the sample to reproduce the issue and let us know so as to proceed further and provide  a prompt solution at the earliest.


Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample1024628671.zip



Ishwarya N

Rilfanayasmin Jamal Nasar [Syncfusion]
Replied On November 3, 2015 03:48 AM UTC

From: Calvin Schrotenboer [mailto:Calvin.Schrotenboer@fox.com]
Sent: 11/02/2015 09:04 AM
To: Syncfusion Support <support@syncfusion.com>
Subject: RE: Syncfusion support community forum 120962, Workbook Name References, has been updated.

                Thanks for this message.

                I built a very simplified sample to illustrate my problem but it did not have the same undesirable  result.  It will take some additional testing for me to either determine what is different/ wrong in our actual working application or to create a sample application which illustrates the problem. 

                I will let you know regardless of which result I find.  Thanks. 


Mathu Mohan Vijayakumar [Syncfusion]
Replied On November 3, 2015 05:06 AM UTC

Hi Calvin,

Thank you for updating us.

We will wait to hear from you.
Mathu Mohan V A


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon