Finally works, but only for ME...!
 

Hi folks,

Last week I inundated this board with questions about the IF command,
and linking to a table in another worksheet.

Well, I worked out all the bugs and now the sheet looks and acts just
fine!

HOWEVER, when I emailed it to my collegues - they only see #### in the
blocks where the data should be appearing! All of the column widths
are more than adequate, so I am a little confused.

I personally use MS Excel 2007, backwards-saved for 2003 compatibility
for my collegues. When I saved, Excel did gripe about a compatibility
error, but it seemed to be about "shadows", or at least it seemed to
concern the visual aspect of the apearance of the workbook, not the
actual guts of the project.

Is there something I should know about backwards-compatibility?

Many thanks,
Craig

Finally works, but only for ME...!
 

Is the Analysis Toolpak Add-In ticked?

Go to Tools/Add0Ins.

"TheMilkGuy" wrote:

Hi folks,

Last week I inundated this board with questions about the IF command,
and linking to a table in another worksheet.

Well, I worked out all the bugs and now the sheet looks and acts just
fine!

HOWEVER, when I emailed it to my collegues - they only see #### in the
blocks where the data should be appearing! All of the column widths
are more than adequate, so I am a little confused.

I personally use MS Excel 2007, backwards-saved for 2003 compatibility
for my collegues. When I saved, Excel did gripe about a compatibility
error, but it seemed to be about "shadows", or at least it seemed to
concern the visual aspect of the apearance of the workbook, not the
actual guts of the project.

Is there something I should know about backwards-compatibility?

Many thanks,
Craig

Finally works, but only for ME...! (revisited)
 

I have found access to another computer with Excel 2003 loaded on
board.

The problem seems to be in linking formulae to other worksheets - I
keep getting a #NAME error, but the help file is not so much helpful.

It says that other sheet's names should be enclosed in single
quotation marks, but when I add them they simply disappear when I
press Enter.

I am confused now!

Craig

On Aug 20, 8:13 am, TheMilkGuy wrote:
Hi folks,

Last week I inundated this board with questions about the IF command,
and linking to a table in another worksheet.

Well, I worked out all the bugs and now the sheet looks and acts just
fine!

HOWEVER, when I emailed it to my collegues - they only see #### in the
blocks where the data should be appearing! All of the column widths
are more than adequate, so I am a little confused.

I personally use MS Excel 2007, backwards-saved for 2003 compatibility
for my collegues. When I saved, Excel did gripe about a compatibility
error, but it seemed to be about "shadows", or at least it seemed to
concern the visual aspect of the apearance of the workbook, not the
actual guts of the project.

Is there something I should know about backwards-compatibility?

Many thanks,
Craig

Finally works, but only for ME...! (revisited)
 

I have found access to another computer with Excel 2003 loaded on
board.

The problem seems to be in linking formulae to other worksheets - I
keep getting a #NAME error, but the help file is not so much helpful.

It says that other sheet's names should be enclosed in single
quotation marks, but when I add them they simply disappear when I
press Enter.

I am confused now!

Craig

On Aug 20, 8:13 am, TheMilkGuy wrote:
Hi folks,

Last week I inundated this board with questions about the IF command,
and linking to a table in another worksheet.

Well, I worked out all the bugs and now the sheet looks and acts just
fine!

HOWEVER, when I emailed it to my collegues - they only see #### in the
blocks where the data should be appearing! All of the column widths
are more than adequate, so I am a little confused.

I personally use MS Excel 2007, backwards-saved for 2003 compatibility
for my collegues. When I saved, Excel did gripe about a compatibility
error, but it seemed to be about "shadows", or at least it seemed to
concern the visual aspect of the apearance of the workbook, not the
actual guts of the project.

Is there something I should know about backwards-compatibility?

Many thanks,
Craig