Hi Greg,

Lets not give up, just yet ;)

I'm confused though, if you are only using 5760 points then why the
message at all. Or do you mean of the +32k rows referenced only 5k
contain values?

Cheers
Andy

Greg G wrote:
I'm replying again just to be sure. I'm only using 5760 data points per
series. I would like to make a sheduled task for this file to open update
and close. This message is the only thing that prevents it from working.
Should I give up on this?

Thank you.

"Andy Pope" wrote:


Hi,

I don't know of anyway too suppress the message.

Any reason why you can not adjust your data series so it only uses the
maximum number of values or following the advice and use extra data series?

Cheers
Andy

Greg G wrote:

Hello,
I would like to know if there is a way to prevent excel from
displaying the alert that says "The maximum number of data points you can use
in a data series for a 2-D chart is 32,000. If you want to use more than
32,000 data points, you must create two or more series." every time that a
chart is opened. It also displays when the file is closed. I've tried
closing the file with a macro with display alerts set to false but it still
appears. You have to click ok before it will continue to close. I would
really appreciate any information about this. Thank you.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info