If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|