Problem launching Excel with an XLSX file

[David Thielen]

Hi;

This case happens when our Word AddIn creates an XLSX file and then does a
Process.Start("filename.xlsx") which launches Excel 2003 (not 2007) on a
system that does have the xlsx filter installed for Excel 2003. We do always
set <calcPr calcCompleted="0'/> since we do not know how to evaluate all the
functions.

When this happens we always get a MessageBox that says:
Microsoft Office Excel
Calculation is incomplete. Recalculate before saving?
Yes, No, Cancel

Clicking Yes causes the dialog to pop up again - only clicking No will bring
the file up in Excel.

While the above always happens, we also sometimes get the following Dialog
Box:
File in Use
CVT72F.tmp is locked for editing

by 'tomasr'.

Open 'Read-On;y' od, click 'Notify' to open in read-only and receive
notification when the document is no longer in use.
Read Only, Notify, Cancel on right side.

For the above, we do not create a file with a tmp extension. The file we
create has a .xlsx extension.

Any idea what is going on and more important, how do we turn off these
prompts?

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

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

 

[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 ([email protected], 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

 

[swastikhotmail]

Hi Jialiang Ge,

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