RE: Problem launching Excel with an XLSX file

[Jialiang Ge [MSFT]]

Hello Dave,

From your post, my understanding on this issue is: you wonder why it pops
out "Calculation is incomplete. Recalculate before saving?" when a xlsx
file whose calcComplete="0" is opened with Office 2007 file format
converter. If I'm off base, please feel free to let me know.

Based on my test, the message box "Calculation is incomplete. Recalculate
before saving?" is shown only if:
1. It is an xlsx file and calcCompleted="0", calcMode="auto".
2. The file is opened in Excel 2003 with Office 2007 file format converter.
Attached is a sample xlsx file that can reproduce the issue. (As you once
mentioned that you could not access the attachments in Newsgroup, I have
sent a copy to your mailbox). The sample works as expected if (a) it is
opened in Excel 2007 directly or (2) it is opened in Excel 2003 but
calcMode="manual".

Therefore, my guess is that it is an issue of the Office 2007 file format
converter. I have sent an email to the product team so as to confirm it. I
will get back to you as soon as possible.

As for the second question about the lock of tmp file, would you let me
know how it happens? Does it happen when you call
Process.Start("filename.xlsx")? Do you have a file named as CVT72F? My
guess is that a process is trying to open and edit a file which is being
edited (or locked) by another process.

Regards,
Jialiang Ge (jia...@online.microsoft.com, remove 'online.')
Microsoft Online Community Support

==================================================
For MSDN subscribers whose posts are left unanswered, please check this
document: http://blogs.msdn.com/msdnts/pages/postingAlias.aspx

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications. If you are using Outlook Express/Windows Mail, please make sure
you clear the check box "Tools/Options/Read: Get 300 headers at a time" to
see your reply promptly.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

[David Thielen]

Hi;

Thank you for confirming the recalc prompt problem and thank you for askign
the Excel group what is happening.

On the locked tmp file, we're at a loss. It happens on just one test system
and only happens sometimes. We are trying to figure out wht it is tied to but
my guess (and it is only a guess) is it is also some issue in the file
converter.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm

[swastik...@gmail.com]

Hi Jialiang Ge,

Would very much appreciate getting a solution for this error message "Calculation is incomplete. Recalculate before saving?"
Regards
Swastik