Hello -
Does anyone out there use the Excel Add-in called Spreadsheet Server (purchased software, not a Microsoft product)?

My company installed MS Office 2007 on my computer. Now I have this issue with all spreadsheets where I am using the Spreadsheet Server Add-in:

I want Cell A10 on Worksheet C to reference the date (no formula) entered in Cell A5 on Worksheet A.

So, I create the simple formula in Worksheet C, Cell A10: =WorksheetA!A5 by doing the following basic steps:

1. I click in Cell A10 on Worksheet C. I type "=" symbol.
2. I select the Worksheet A tab.
3. I click on Cell A5 to select that cell containing the date (no formula in this cell, just a date in date format).
4. I press ENTER.
5. Instead of the date appearing in Cell A10 of Worksheet C, it appears in Cell A5 of Worksheet C (with the cell reference formula in the address bar). Cell A10, where I wanted the reference to appear, is blank.

It seems that no matter where the the cell is in which I enter the formula, the result (and underlying formula) always appears on the destination worksheet in the same cell the referenced date is in. For example, if I am referencing the date entered in Cell A5 of Worksheet A, no matter what worksheet or cell in which I enter the cell reference formula (Worksheet B, Cell B6; Worksheet C, cell H19; etc.), the result will always be in Cell A5 of the destination worksheet.

Can anyone help? Anyone had this issue?

Thank you,
Andi