software

I am having trouble with some spreadsheets I create on one system and then
move over to another system for people to view. Used to be, I would do this
and you could open the spreadsheet up and see the values. Recently, and what
changed I don't know, when the spreadsheets are opened I get the #NAME? error
in all the fields, as if Excel is trying to recalculate upon opening - and
failing, since the spreadsheets were created using Citrix, which doesn't
exist on the second system. How do I keep this from happening - short of
doing a values-only copy of each spreadsheet? Any insight is greatly
appreciated.

Tom Hayakawa

Have you tried setting calculation to quot;Manualquot;?

lt;Toolsgt; lt;Optionsgt; lt;Calculationgt; tab.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;Tom Hayakawaquot; gt; wrote in message
...
gt; I am having trouble with some spreadsheets I create on one system and then
gt; move over to another system for people to view. Used to be, I would do
this
gt; and you could open the spreadsheet up and see the values. Recently, and
what
gt; changed I don't know, when the spreadsheets are opened I get the #NAME?
error
gt; in all the fields, as if Excel is trying to recalculate upon opening - and
gt; failing, since the spreadsheets were created using Citrix, which doesn't
gt; exist on the second system. How do I keep this from happening - short of
gt; doing a values-only copy of each spreadsheet? Any insight is greatly
gt; appreciated.
gt;
gt; Tom HayakawaHi Tom,

If there are different versions of Excel, it sometimes indeed will
recalculate a workbook upon loading
If on the other systems there are missing components (like Analysis Toolpak
not being loaded) you can get #NAME errors.
If the readers don't need to change the workbook, why not use an Excel
viewer?

www.microsoft.com/downloads/d...displaylang=EN

mind possible linewraps
--
Kind regards,

Niek Otten

quot;Tom Hayakawaquot; gt; wrote in message
...
gt;I am having trouble with some spreadsheets I create on one system and then
gt; move over to another system for people to view. Used to be, I would do
gt; this
gt; and you could open the spreadsheet up and see the values. Recently, and
gt; what
gt; changed I don't know, when the spreadsheets are opened I get the #NAME?
gt; error
gt; in all the fields, as if Excel is trying to recalculate upon opening - and
gt; failing, since the spreadsheets were created using Citrix, which doesn't
gt; exist on the second system. How do I keep this from happening - short of
gt; doing a values-only copy of each spreadsheet? Any insight is greatly
gt; appreciated.
gt;
gt; Tom Hayakawa
Thanks - That is a possible solution.

quot;RagDyerquot; wrote:

gt; Have you tried setting calculation to quot;Manualquot;?
gt;
gt; lt;Toolsgt; lt;Optionsgt; lt;Calculationgt; tab.
gt; --
gt; HTH,
gt;
gt; RD
gt; ==============================================
gt; Please keep all correspondence within the Group, so all may benefit!
gt; ==============================================
gt;
gt;
gt; quot;Tom Hayakawaquot; gt; wrote in message
gt; ...
gt; gt; I am having trouble with some spreadsheets I create on one system and then
gt; gt; move over to another system for people to view. Used to be, I would do
gt; this
gt; gt; and you could open the spreadsheet up and see the values. Recently, and
gt; what
gt; gt; changed I don't know, when the spreadsheets are opened I get the #NAME?
gt; error
gt; gt; in all the fields, as if Excel is trying to recalculate upon opening - and
gt; gt; failing, since the spreadsheets were created using Citrix, which doesn't
gt; gt; exist on the second system. How do I keep this from happening - short of
gt; gt; doing a values-only copy of each spreadsheet? Any insight is greatly
gt; gt; appreciated.
gt; gt;
gt; gt; Tom Hayakawa
gt;
gt;

Thanks - that's exactly right. Duh, why didn't I think of that?

quot;Niek Ottenquot; wrote:

gt; Hi Tom,
gt;
gt; If there are different versions of Excel, it sometimes indeed will
gt; recalculate a workbook upon loading
gt; If on the other systems there are missing components (like Analysis Toolpak
gt; not being loaded) you can get #NAME errors.
gt; If the readers don't need to change the workbook, why not use an Excel
gt; viewer?
gt;
gt; www.microsoft.com/downloads/d...displaylang=EN
gt;
gt; mind possible linewraps
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Tom Hayakawaquot; gt; wrote in message
gt; ...
gt; gt;I am having trouble with some spreadsheets I create on one system and then
gt; gt; move over to another system for people to view. Used to be, I would do
gt; gt; this
gt; gt; and you could open the spreadsheet up and see the values. Recently, and
gt; gt; what
gt; gt; changed I don't know, when the spreadsheets are opened I get the #NAME?
gt; gt; error
gt; gt; in all the fields, as if Excel is trying to recalculate upon opening - and
gt; gt; failing, since the spreadsheets were created using Citrix, which doesn't
gt; gt; exist on the second system. How do I keep this from happening - short of
gt; gt; doing a values-only copy of each spreadsheet? Any insight is greatly
gt; gt; appreciated.
gt; gt;
gt; gt; Tom Hayakawa
gt;
gt;
gt;