I'm using WF 5.2.3 and my problem is in regards to Excel 2K limitations.

I have a program that needs to be in Excel, but it exceeds the approximately 65,000 limit of rows. The PCHOLD OPEN/CLOSE option in Excel will not work from what I've read in WF 5.2.3. Is there another way around this so that I can have the 90,000+ show up in an Excel spreadsheet(s)?

Thanks for any help you can give me or point me towards.

64K rows is not a WebFocus Limit it is a Microsoft Excel limit.

An Excel document CAN NOT contain more than 64K Rows (I believe 95 and before it was 32k Rows).
WebFocus can deliver more but Excel cannot display them. Even the mighty SAP & IBM have not been able to work around this.

I think most spreadsheet applications have this problem.

Good news/bad news. There is a technique to get around this limitation but you need WebFOCUS 5.3.2 to do it. Brian Carter spoke about it at Summit (and wrote about it in the April 2005 WF Newsletter if you want more info).

In WF 5.3.2 you can produce multiple worksheets in a single workbook. In simple terms you burst the data by using a BY field and PCHOLD FORMAT EXL2K BYTOC. Here's a version of Brian's example:

TABLE FILE filename
PRINT field1 field2
COMPUTE COUNTER/I9 = COUNTER + 1;
COMPUTE WORKSHEET/I4 = COUNTER/65500;
ON TABLE HOLD AS EXL65K FORMAT ALPHA
END

TABLE FILE EXL65K
PRINT field1 field2
BY WORKSHEET NOPRINT
ON TABLE PCHOLD FORMAT EXL2K BYTOC
END

Doesn't solve your immediate problem I'm afraid, but I wanted to mention it anyway.

Depending on your application, you might want to look at EXL2K PIVOT. The pivot cache can have more than 65K rows. If the end user is keeping the result in Excel to analyze, this might be an option.

Previously in Focus reports, we would set up a counter and then divy it up in chunks and combine the reports outside of Focus.

TABLE FILE HOLD1
PRINT *
BY CID_LC
WHERE (COUNTER GE 50001) AND (COUNTER LE 65000)
ON TABLE HOLD AS HOLD2 FORMAT LOTUS
END

Since FORMAT LOTUS doesn't seem to be an option where you can do it 3 times in the same report and just have the 3 .prn files sitting in your directory to download and use, what is one to do now while waiting for 5.3 to be installed? Or, can you do something similar to this in WebFOCUS?

Thanks for your replies. I'll just make the best of what I can do now.

i agree with N.Selph. it is poss to have >65k records in your xml sheet that exl2k pivot reads, if you CACHEFIELDS and/or assiduously use PAGEFIELDS.
but your user has got to have a wicked amount of memory locally to handle.