"NCOMPLETE CALCULATION"message
 

Not really the correct forum for this little question - but there's as
much of a chance of an answer here as any other forum

Spreadsheet A has several links to Spreadsheet B and spreadsheet
C.Usually everything is a.o.k, but at the moment when I open spdsht A
I get a message "Incomplete Calculation in sprdsht B" and then another
one "Incomplete Calculation in sprdsht C".

Both B and C are closed at the time, and when I look in the cells in
spdsht A with the links in, them they look fine.There are other links
in A to other sheets (D,E,F etc) but the message doesn't come up for
them!

It must be something that has happened to B and C, but I can't work
out what.I have a macro which takes copies of B and C (and exits them
without saving any changes) for another purpose - could this be
inadvertantly doing something to them ?!

Any help greatly appreciated.

Regards,
Jason.

"NCOMPLETE CALCULATION"message
 

Not sure, but this might be germane.

http://support.microsoft.com/default...b;en-us;214360


In article ,
(jason) wrote:

Not really the correct forum for this little question - but there's as
much of a chance of an answer here as any other forum

Spreadsheet A has several links to Spreadsheet B and spreadsheet
C.Usually everything is a.o.k, but at the moment when I open spdsht A
I get a message "Incomplete Calculation in sprdsht B" and then another
one "Incomplete Calculation in sprdsht C".

Both B and C are closed at the time, and when I look in the cells in
spdsht A with the links in, them they look fine.There are other links
in A to other sheets (D,E,F etc) but the message doesn't come up for
them!

It must be something that has happened to B and C, but I can't work
out what.I have a macro which takes copies of B and C (and exits them
without saving any changes) for another purpose - could this be
inadvertantly doing something to them ?!

Any help greatly appreciated.

Regards,
Jason.

"NCOMPLETE CALCULATION"message
 

Cheers,
This looks like the problem - I think I need to check the options
setting of all the people who may have been in the spdshts before we
went into the linked sheet.I'll report back as to whether anyone has
saved it in this manual calculation form.

Thanks again
J

"J.E. McGimpsey" wrote in message ...
Not sure, but this might be germane.

http://support.microsoft.com/default...b;en-us;214360


In article ,
(jason) wrote:

Not really the correct forum for this little question - but there's as
much of a chance of an answer here as any other forum

Spreadsheet A has several links to Spreadsheet B and spreadsheet
C.Usually everything is a.o.k, but at the moment when I open spdsht A
I get a message "Incomplete Calculation in sprdsht B" and then another
one "Incomplete Calculation in sprdsht C".

Both B and C are closed at the time, and when I look in the cells in
spdsht A with the links in, them they look fine.There are other links
in A to other sheets (D,E,F etc) but the message doesn't come up for
them!

It must be something that has happened to B and C, but I can't work
out what.I have a macro which takes copies of B and C (and exits them
without saving any changes) for another purpose - could this be
inadvertantly doing something to them ?!

Any help greatly appreciated.

Regards,
Jason.

"NCOMPLETE CALCULATION"message
 

Mr McGimpsey,
Most definitely Germane.
My calcaltion was not the culprit, so I simply went into the offending
spdshts and pressed save and the problem was solved

Thanks again.
J

"J.E. McGimpsey" wrote in message ...
Not sure, but this might be germane.

http://support.microsoft.com/default...b;en-us;214360


In article ,
(jason) wrote:

Not really the correct forum for this little question - but there's as
much of a chance of an answer here as any other forum

Spreadsheet A has several links to Spreadsheet B and spreadsheet
C.Usually everything is a.o.k, but at the moment when I open spdsht A
I get a message "Incomplete Calculation in sprdsht B" and then another
one "Incomplete Calculation in sprdsht C".

Both B and C are closed at the time, and when I look in the cells in
spdsht A with the links in, them they look fine.There are other links
in A to other sheets (D,E,F etc) but the message doesn't come up for
them!

It must be something that has happened to B and C, but I can't work
out what.I have a macro which takes copies of B and C (and exits them
without saving any changes) for another purpose - could this be
inadvertantly doing something to them ?!

Any help greatly appreciated.

Regards,
Jason.