Can't export calculated fields to Excel

I tried John's suggestion and it works. I'm using Office 2000 and Access 2000. First, Tools, Office Links, Publish it with MS Word. Then in Word highlight cells, copy, and paste into Excel spreadsheet. Calculations are transferred as absolute values.

----- John Spencer (MVP) wrote: -----

Yeah, that is a problem. I don't know any fix to that, since when you export to
Excel, it seems to only export the Group headers and details sections. You
might try exporting to WORD and then copying the data from word over to excel.

I can't experiment right now, or I would try to come up with a better solution.

Diane Yocom wrote:
I dropped the colon and that made no difference and there are no slashes in
SelAgency.
I did determine that this particular field would print out if it was moved
to a Group Header or to the Detail section, but it wouldn't print in the
Report Header, Page Header, or any footer sections.
But this field isn't really the biggest of my problems, I don't care much if
the title of the report doesn't export, but I have a bunch of calculated
fields in group footer sections (sums and counts) that just aren't showing
up and that's a problem!
Diane
"John Spencer (MVP)" wrote in message
...
Have you tried changing the name (title)? Try dropping the colon and see
if
that helps. Or if there are slashes in the SelAgency field try dropping
those.
Diane Yocom wrote:
I have several reports that do summing in the group and report footer
sections. They work fine in Access, but when I try to Export them to
Excel
97, I get an error message saying that the following error was detected,
but
was repaired: "Renamed invalid sheet name". When I click OK, the
spreadsheet comes up blank.
I believe I've narrowed the problem down to the fact that I have a bunch
of
calculated fields. To support that theory, I've also found reports that
mostly come through fine except for the title which is a calculated
field
like: ="Priority Outreach Participants By Agency: " & UCase([SelAgency]).
In that case, the title comes through blank, but the rest of the report
is
fine. and, I've got other reports with no calculated fields that also
export just fine.
If I export to RTF or HTML and then open in Excel, the data gets into
Excel
fine, though the formatting is messed up. This is more work than my
users
would like to do, so I'm hoping there's some way to get reports with
calculated fields to export properly. Any thoughts?
TIA,
Diane