I hope I can explain this....

I have an Excel spreadsheet that feeds an Access database (one time). We
update the database frequently. At least once a day we export data to Excel
in a worksheet; however this worksheet is not in the format we need. So we
have the data in this spreadsheet linked to another worksheet (same workbook)
with the formulas we use. The problem we are encountering is that the
values we get with the columns with formulas are not calculating correctly.
The cell values in the columns are suppose to be dates or "yes/no"; the
formulas are simple counta or count functions. What is happening is that
everything is being counted whether the cell has an actual value or not.
When you click in the blank cell it shows "=RawData!L5", RawData is the
worksheet that Access exports the data to.

We do this instead of a "report" in Access because our higher headquarters
requires this data in Excel and doesn't use Access.

Appreciate any help.

Sorry for the confusion on the topic...data imported into Excel from Access.

"Bernie R." wrote:

I hope I can explain this....

I have an Excel spreadsheet that feeds an Access database (one time). We
update the database frequently. At least once a day we export data to Excel
in a worksheet; however this worksheet is not in the format we need. So we
have the data in this spreadsheet linked to another worksheet (same workbook)
with the formulas we use. The problem we are encountering is that the
values we get with the columns with formulas are not calculating correctly.
The cell values in the columns are suppose to be dates or "yes/no"; the
formulas are simple counta or count functions. What is happening is that
everything is being counted whether the cell has an actual value or not.
When you click in the blank cell it shows "=RawData!L5", RawData is the
worksheet that Access exports the data to.

We do this instead of a "report" in Access because our higher headquarters
requires this data in Excel and doesn't use Access.

Appreciate any help.

Take a look at this:
http://www.rondebruin.nl/accessexcel.htm


Regards,
Ryan---

--
RyGuy


"Bernie R." wrote:

Sorry for the confusion on the topic...data imported into Excel from Access.

"Bernie R." wrote:

I hope I can explain this....

I have an Excel spreadsheet that feeds an Access database (one time). We
update the database frequently. At least once a day we export data to Excel
in a worksheet; however this worksheet is not in the format we need. So we
have the data in this spreadsheet linked to another worksheet (same workbook)
with the formulas we use. The problem we are encountering is that the
values we get with the columns with formulas are not calculating correctly.
The cell values in the columns are suppose to be dates or "yes/no"; the
formulas are simple counta or count functions. What is happening is that
everything is being counted whether the cell has an actual value or not.
When you click in the blank cell it shows "=RawData!L5", RawData is the
worksheet that Access exports the data to.

We do this instead of a "report" in Access because our higher headquarters
requires this data in Excel and doesn't use Access.

Appreciate any help.