Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Opening xls from a different version of Excel

Status
Not open for further replies.

notuserfriendly

Programmer
May 7, 2004
82
0
0
SE
Hi

I'm wondering how to cope with the question
given by Excel to recalculate the formulas in
the opened .xls (happens when an Excel workbook
is opened by someone with a newer version of Excel).

Do I have to remove alerts and open the file
or is it some way to open the file and
answer the question or ignore it?

/I
 
If Application.CalculationVersion <> _
Workbook.CalculationVersion Then
Application.CalculateFullRebuild
End If
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top