View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pt_lily pt_lily is offline
external usenet poster
 
Posts: 17
Default Pivot Table Help - Work Around Cell Limit?

I have a Pivot Table that I am using that is pulling data from our customer
database. I have several "notes" fields in the database that contain more
text than the Excel limit. I get the error when I try to import them into
the database. Is there a way to work around this? Perhaps a way to tell
Excel to break the data into multiple cells when needed?

Any help is much appreciated.