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 strongm 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
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