Notices



Reply
 
LinkBack Thread Tools Display Modes

Old 11-20-2007, 02:00 PM   #1 (permalink)
Junior Member

Join Date: Aug 2007
Location: New York City
Posts: 2
Rep Power: 0 Aura Lopez is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)

Pivot report "freezes" when opening in Excel

I have a pivot report that includes about 50,000 gifts. Everything runs fine until I click on the Export to Excel icon. When Excel opens I click on the Enable Automatic refresh, but the data in the rows and columns never shows up. However, if I press the Esc button I can see the Field list, and I can drag the fields and only then the data appears. Of course, it took me a while to figure this trick out.

I'm using Excel 2003 SP3. I don't have problems like this with smaller reports. Support cannot help me with this because it is a "third" party application. Is anybody else having the same problem? I have tried to look something up in the Excel Knowledgebase, but couldn't find anything.

Thanks! Aura
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 12-03-2007, 01:05 PM   #2 (permalink)
Donor Relations

SLewis's Avatar

Join Date: Aug 2007
Location: Waco, TX
Posts: 26
Rep Power: 0 SLewis is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

I was told you can only open up to 44,000 records in excel - that might be the problem
__________________
Stephanie Lewis
Methodist Children's Home
Waco, TX
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 12-03-2007, 01:10 PM   #3 (permalink)
RDC:RE Guy

mwittman's Avatar

Join Date: Sep 2007
Posts: 155
Rep Power: 2 mwittman is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- NetCommunity (BBNC)

Quote:
Originally Posted by Aura Lopez View Post
I have a pivot report that includes about 50,000 gifts. Everything runs fine until I click on the Export to Excel icon. When Excel opens I click on the Enable Automatic refresh, but the data in the rows and columns never shows up. However, if I press the Esc button I can see the Field list, and I can drag the fields and only then the data appears. Of course, it took me a while to figure this trick out.

I'm using Excel 2003 SP3. I don't have problems like this with smaller reports. Support cannot help me with this because it is a "third" party application. Is anybody else having the same problem? I have tried to look something up in the Excel Knowledgebase, but couldn't find anything.

Thanks! Aura
I think this may get at the root of the limitation you're experiencing:

Description of the limits of PivotTable reports in Excel
__________________
Micah Wittman

WORK

Database Coordinator
Red Deer College
blackbus4.m.wittman@xoxy.net

PERSONAL

http://bebepool.com
http://hmatters.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
pivot issues


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Cheap Gas - Loans - United Specialties - Loans
All times are GMT -6. The time now is 03:37 AM.

Miscellaneous


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by BBpixel Team 2008 :: jvbPlugin R1012.364.1

SEO by vBSEO 3.2.0 Copyright 2008 Blackbaud User SocietyAd Management by RedTyger
Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64