When Opeing an Excel 02 File in Excel 03 I do not want refresh

[Guest]

I have an application that saves the Excel File in the 2002 format. I have
users that have Excel 2003 when I send the file to the 2003 users the 2003
automatically refreshes. I do not want this automatic refresh to occur. How
do I stop Excel 2003 from wanting to refresh Excel 2002 Files.

 

[Jim Rech]

If by 'refresh' you mean recalculate, create a new Dword registry entry
"FullCalcOnLoadOldFile" under:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options

and leave its value as 0.

--
Jim
|I have an application that saves the Excel File in the 2002 format. I have
| users that have Excel 2003 when I send the file to the 2003 users the 2003
| automatically refreshes. I do not want this automatic refresh to occur.
How
| do I stop Excel 2003 from wanting to refresh Excel 2002 Files.
| --
| GPUtilizer

 

[Guest]

Jim,

Thanks for your response. I do mean recalc. The app we are using has
specific formulas that native Excel cannot read so the recalc is causing
#name? to occur. We are on Citirx. Do you know if the Current_User registry
setting will still work?

Again thank you for your response.

Phil

 

[Jim Rech]

I've had hear of cases where a workbook calced despite this registry entry
but others where it worked. No harm in trying it as you can always delete
the entry.

--
Jim
| Jim,
|
| Thanks for your response. I do mean recalc. The app we are using has
| specific formulas that native Excel cannot read so the recalc is causing
| #name? to occur. We are on Citirx. Do you know if the Current_User
registry
| setting will still work?
|
| Again thank you for your response.
|
| Phil
| --
| GPUtilizer
|
|
| "Jim Rech" wrote:
|
| > If by 'refresh' you mean recalculate, create a new Dword registry entry
| > "FullCalcOnLoadOldFile" under:
| >
| > HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options
| >
| > and leave its value as 0.
| >
| > --
| > Jim
| > | > |I have an application that saves the Excel File in the 2002 format. I
have
| > | users that have Excel 2003 when I send the file to the 2003 users the
2003
| > | automatically refreshes. I do not want this automatic refresh to
occur.
| > How
| > | do I stop Excel 2003 from wanting to refresh Excel 2002 Files.
| > | --
| > | GPUtilizer
| >
| >
| >