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

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

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options

and leave its value as 0.

--
Jim
"GPutilizer" wrote in message
...
|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

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\E xcel\Options

and leave its value as 0.

--
Jim
"GPutilizer" wrote in message
...
|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

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
"GPutilizer" wrote in message
...
| 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\E xcel\Options
|
| and leave its value as 0.
|
| --
| Jim
| "GPutilizer" wrote in message
| ...
| |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
|
|
|