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

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\Excel\Options

and leave its value as 0.

--
Jim
"GPutilizer" <GPutilizer@discussions.microsoft.com> wrote in message
news:31A51F15-D358-4C8A-89AE-B3B5B0CD31F2@microsoft.com...
|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\Excel\Options
>
> and leave its value as 0.
>
> --
> Jim
> "GPutilizer" <GPutilizer@discussions.microsoft.com> wrote in message
> news:31A51F15-D358-4C8A-89AE-B3B5B0CD31F2@microsoft.com...
> |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" <GPutilizer@discussions.microsoft.com> wrote in message
news:3A82B38B-1814-42F1-B6A8-96DAFEA40ABA@microsoft.com...
| 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
| > "GPutilizer" <GPutilizer@discussions.microsoft.com> wrote in message
| > news:31A51F15-D358-4C8A-89AE-B3B5B0CD31F2@microsoft.com...
| > |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
| >
| >
| >