Excel R1C1 referencing

45 pts.
Tags:
Crystal Reports
Crystal Reports Export to Excel
excel
Excel 2000
Excel 2003
Excel 2007
Spreadsheet functions
I have an excel spread sheet created via Crystal Reports export as a data only 2000-2003 excel (xls).
Within this spread sheet are cells containing formulas with R1C1 referencing.
When I open the spread sheet, the formulas are not calculated. I have changed cell referencing to R1C1 via the Office button, formula options, but the formulas are still not calculated. You can see the R1C1 formulas and if you click on 1 of the formulas (moving the formula into the formula edit area), place the cursor at the end of the formula, and press "enter", the formula is calculated properly. 
There are thousands of these R1C1 formulas on the spread sheet. Is there any way get excel to first recognize these cells as formulas with R1C1 referencing, then calculate the formulas throughout the spread sheet? 


Software/Hardware used:
Excel 2007

Answer Wiki

Thanks. We'll let you know when a new response is added.

Have you checked under Tools Options Calculations to see if Crystal is creating a report that has the Calculations option set to manual?

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • arndtwc

    In Excel - Tools - Options, under the Calculation Tab, Is the Calculation set to Automatic or Manual (F9)?

    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following