Dealing with Excel 2003's data limits

[willy91785]

Hi all -

Was wondering if you have discovered any tricks when dealing with Excel 2003's limitations on rows/columns and amount of data points that can be used in a chart (32,000)? Any advice would be great.

[shg]

Tricks for what?

[willy91785]

Well, for example, I've had situations when I max out rows on one sheet and have to put the rest of the data on another and cannot use data from both sheets to make a pivot table. Also, I haven't been able to create an accurate graph because of the 32,000 data point limit. Just looking to see if users have had similar/other problems related to this and potential work arounds.