LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
MAK MAK is offline
external usenet poster
 
Posts: 20
Default 2007 Excel Pivot Tables - Error Message too many records? Help

My data worksheet is only 1,404 rows and 13 columns (not all data being used)
- but every time I try and add a formula I get an message: "There are too
many records to complete the operation".

I also have an issue when I go to move from items between the columns and
rows - it takes over 15 minutes to refresh.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Error Message Chuck Excel Discussion (Misc queries) 4 November 4th 09 10:36 PM
Pivot Table Error Message - "too many records" Excel 2007 MAK Excel Discussion (Misc queries) 0 November 5th 08 09:19 PM
Building pivot tables in Excel 2007 based on existing pivot tables? [email protected] Excel Discussion (Misc queries) 4 December 26th 07 08:05 PM
Error message in Excel 2007 tim Excel Discussion (Misc queries) 0 July 23rd 07 09:36 PM
Excel 2007 Error Reopening Pivot tables Mike L Setting up and Configuration of Excel 6 November 24th 06 09:53 PM


All times are GMT +1. The time now is 07:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"