As part of a Perl application I read in spreadsheets. One spreadsheet is exchanged on a regular basis with a customer.

Suddenly I now get a Microsoft Excel message ‘warning’ which says

“Do you want to save the changes to the spreadsheet that I simply reading in? Microsoft Excel recalculates formulas when opening files last saved by an earlier version of Excel.”

There are 3 buttons for Save, Don’t_Save and Cancel.

The spreadsheets have an .xls extension. I just have started using Excel 2010. My customer is using an earlier version.

I have tried saving a file from the customer as an Excel .xlsx format and then resaving as an .xls but this did not work.

I have looked in the Options for Excel as I suspect one of them will sort the problem. However I could not find one that seemed to relate to this problem.

Thank you in anticipation for any thought you have on this.

In reply to (OT) Excel reading problem by merrymonk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.