Send and Refresh Active Workbook

[Former Member]

Hello,

I added a second worksheet to an input schedule and am having an issue with all the records not sending.

The 1st workbook has 113 columns and the 2nd workbook has 63, although the columns are not set to expand I have the workbook option set to 200 columns. The 1st workbook has 684 sends, the 2nd workbook has 96. When I send the worksheets seperately, everything works fine. But when I select send and refresh active workbook...only 763 records send when there are 780 records. I am using Excel 2007 and have tried saving the workbook as xls and xlsx. I am on BPC v7.0 SP3. I have also tested creating a new workbook and deleting sends to determine which ones are not sending. The last column in the 2nd workseet sends, but the 17 sends in the columns before the last column do not send. Also, they are EVSEN and I have tried using EVSND as well and get the same issue.

Any ideas or suggestions?!

Thanks!

Ricki Mathine

[Former Member · Accepted solution]

Hi,

This might happen due to the fact that there are some common data regions in the 2 schedules, to which data is being sent. Please verify if this is the case or not.

[Former Member]

That's it!!! Just one of those things that you spend hours looking at but it just doesn't come to you what's going on!

Thanks so much.

Ricki