Sage 100

Have you seen this?

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=240130164747270&page=1&position=1&q=240130164747270

I search KB and nothing like that came up. This is great. Thank you for the resource.

Have you seen this?

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=240130164747270&page=1&position=1&q=240130164747270

Is there something in the WATER???  Just received a client email on this exact topic.  Life has been good with SI for over ten years and now this.  Could this be related to this thread?

Microsoft update breaks Excel-Addins (MS Excel 2016 - MSI) | Sage 100

Also, has anyone used the 4Gpatch solution reference in the KB?  Is this it?  4GB Patch – NTCore

Would this memory limitation disappear if a 64 bit version of Excel was being used?

C. 4GB Patch Solution 

Disclaimer:

The solution discussed below is not a Sage product and as such Sage is unable to support it. 

Consider applying the 4GB Patch solution to resolve the above reporting error. 

4GB Patch is a tiny software solution that can help you tweak your x86 programs so that they can make use of up to 4 GB of RAM, when running on a x64 PC. 

Using the 4GB Patch can be used to successfully increase the memory usage in Sage Intelligence's BICore.exe file to run with extra rows. It can therefore reduce the instances where this error impacts reports. 

Please consult with your local IT technician to access and properly install it on your PC. 

When done, you should be able to run large data set reports in Sage Intelligence.

I search KB and nothing like that came up. This is great. Thank you for the resource.

Have you seen this?

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=240130164747270&page=1&position=1&q=240130164747270

@Dana Halpin Any progress?

Is there something in the WATER???  Just received a client email on this exact topic.  Life has been good with SI for over ten years and now this.  Could this be related to this thread?

Microsoft update breaks Excel-Addins (MS Excel 2016 - MSI) | Sage 100

Also, has anyone used the 4Gpatch solution reference in the KB?  Is this it?  4GB Patch – NTCore

Would this memory limitation disappear if a 64 bit version of Excel was being used?

C. 4GB Patch Solution 

Disclaimer:

The solution discussed below is not a Sage product and as such Sage is unable to support it. 

Consider applying the 4GB Patch solution to resolve the above reporting error. 

4GB Patch is a tiny software solution that can help you tweak your x86 programs so that they can make use of up to 4 GB of RAM, when running on a x64 PC. 

Using the 4GB Patch can be used to successfully increase the memory usage in Sage Intelligence's BICore.exe file to run with extra rows. It can therefore reduce the instances where this error impacts reports. 

Please consult with your local IT technician to access and properly install it on your PC. 

When done, you should be able to run large data set reports in Sage Intelligence.

I search KB and nothing like that came up. This is great. Thank you for the resource.

Have you seen this?

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=240130164747270&page=1&position=1&q=240130164747270

The client reported that the report was generated without issue this AM.

She is connected via RDP so perhaps an overnight reboot cleared the issues.  Short-term solution?

@Dana Halpin Any progress?

Is there something in the WATER???  Just received a client email on this exact topic.  Life has been good with SI for over ten years and now this.  Could this be related to this thread?

Microsoft update breaks Excel-Addins (MS Excel 2016 - MSI) | Sage 100

Also, has anyone used the 4Gpatch solution reference in the KB?  Is this it?  4GB Patch – NTCore

Would this memory limitation disappear if a 64 bit version of Excel was being used?

C. 4GB Patch Solution 

Disclaimer:

The solution discussed below is not a Sage product and as such Sage is unable to support it. 

Consider applying the 4GB Patch solution to resolve the above reporting error. 

4GB Patch is a tiny software solution that can help you tweak your x86 programs so that they can make use of up to 4 GB of RAM, when running on a x64 PC. 

Using the 4GB Patch can be used to successfully increase the memory usage in Sage Intelligence's BICore.exe file to run with extra rows. It can therefore reduce the instances where this error impacts reports. 

Please consult with your local IT technician to access and properly install it on your PC. 

When done, you should be able to run large data set reports in Sage Intelligence.

I search KB and nothing like that came up. This is great. Thank you for the resource.

Have you seen this?

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=240130164747270&page=1&position=1&q=240130164747270

Hi Jeff I don't have an update yet but will report back soon. Customer's IT took it over.

The client reported that the report was generated without issue this AM.

She is connected via RDP so perhaps an overnight reboot cleared the issues.  Short-term solution?

@Dana Halpin Any progress?

Is there something in the WATER???  Just received a client email on this exact topic.  Life has been good with SI for over ten years and now this.  Could this be related to this thread?

Microsoft update breaks Excel-Addins (MS Excel 2016 - MSI) | Sage 100

Also, has anyone used the 4Gpatch solution reference in the KB?  Is this it?  4GB Patch – NTCore

Would this memory limitation disappear if a 64 bit version of Excel was being used?

C. 4GB Patch Solution 

Disclaimer:

The solution discussed below is not a Sage product and as such Sage is unable to support it. 

Consider applying the 4GB Patch solution to resolve the above reporting error. 

4GB Patch is a tiny software solution that can help you tweak your x86 programs so that they can make use of up to 4 GB of RAM, when running on a x64 PC. 

Using the 4GB Patch can be used to successfully increase the memory usage in Sage Intelligence's BICore.exe file to run with extra rows. It can therefore reduce the instances where this error impacts reports. 

Please consult with your local IT technician to access and properly install it on your PC. 

When done, you should be able to run large data set reports in Sage Intelligence.

I search KB and nothing like that came up. This is great. Thank you for the resource.

Have you seen this?

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=240130164747270&page=1&position=1&q=240130164747270

Still working on this issue. Workstation only had 8 GB ram so we decided to try report on a workstation with 32 GB of ram and same error. Report has 10 sheets and the max rows on a sheet is 270,000 so it's not exceeding the excel limitation. However, I started removing one sheet at a time as a test and report ran fine after removing 3 sheets. So maybe is it an excel limit issue? IT doesn't feel comfortable trying that 4 GB patch. Microsoft® Excel version is Microsoft 365 MSO (Version 2411 Build 16.0.18227.20082) 64-bit. 

Hi Jeff I don't have an update yet but will report back soon. Customer's IT took it over.

The client reported that the report was generated without issue this AM.

She is connected via RDP so perhaps an overnight reboot cleared the issues.  Short-term solution?

@Dana Halpin Any progress?

Is there something in the WATER???  Just received a client email on this exact topic.  Life has been good with SI for over ten years and now this.  Could this be related to this thread?

Microsoft update breaks Excel-Addins (MS Excel 2016 - MSI) | Sage 100

Also, has anyone used the 4Gpatch solution reference in the KB?  Is this it?  4GB Patch – NTCore

Would this memory limitation disappear if a 64 bit version of Excel was being used?

C. 4GB Patch Solution 

Disclaimer:

The solution discussed below is not a Sage product and as such Sage is unable to support it. 

Consider applying the 4GB Patch solution to resolve the above reporting error. 

4GB Patch is a tiny software solution that can help you tweak your x86 programs so that they can make use of up to 4 GB of RAM, when running on a x64 PC. 

Using the 4GB Patch can be used to successfully increase the memory usage in Sage Intelligence's BICore.exe file to run with extra rows. It can therefore reduce the instances where this error impacts reports. 

Please consult with your local IT technician to access and properly install it on your PC. 

When done, you should be able to run large data set reports in Sage Intelligence.

I search KB and nothing like that came up. This is great. Thank you for the resource.

Have you seen this?

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=240130164747270&page=1&position=1&q=240130164747270

Still working on this issue. Workstation only had 8 GB ram so we decided to try report on a workstation with 32 GB of ram and same error. Report has 10 sheets and the max rows on a sheet is 270,000 so it's not exceeding the excel limitation. However, I started removing one sheet at a time as a test and report ran fine after removing 3 sheets. So maybe is it an excel limit issue? IT doesn't feel comfortable trying that 4 GB patch. Microsoft® Excel version is Microsoft 365 MSO (Version 2411 Build 16.0.18227.20082) 64-bit. 

Hi Jeff I don't have an update yet but will report back soon. Customer's IT took it over.

The client reported that the report was generated without issue this AM.

She is connected via RDP so perhaps an overnight reboot cleared the issues.  Short-term solution?

@Dana Halpin Any progress?

Is there something in the WATER???  Just received a client email on this exact topic.  Life has been good with SI for over ten years and now this.  Could this be related to this thread?

Microsoft update breaks Excel-Addins (MS Excel 2016 - MSI) | Sage 100

Also, has anyone used the 4Gpatch solution reference in the KB?  Is this it?  4GB Patch – NTCore

Would this memory limitation disappear if a 64 bit version of Excel was being used?

C. 4GB Patch Solution 

Disclaimer:

The solution discussed below is not a Sage product and as such Sage is unable to support it. 

Consider applying the 4GB Patch solution to resolve the above reporting error. 

4GB Patch is a tiny software solution that can help you tweak your x86 programs so that they can make use of up to 4 GB of RAM, when running on a x64 PC. 

Using the 4GB Patch can be used to successfully increase the memory usage in Sage Intelligence's BICore.exe file to run with extra rows. It can therefore reduce the instances where this error impacts reports. 

Please consult with your local IT technician to access and properly install it on your PC. 

When done, you should be able to run large data set reports in Sage Intelligence.

I search KB and nothing like that came up. This is great. Thank you for the resource.

Have you seen this?

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=240130164747270&page=1&position=1&q=240130164747270

This link has ideas on how to optimize Excel to use less memory.

https://learn.microsoft.com/en-us/office/troubleshoot/excel/clean-workbook-less-memory

Still working on this issue. Workstation only had 8 GB ram so we decided to try report on a workstation with 32 GB of ram and same error. Report has 10 sheets and the max rows on a sheet is 270,000 so it's not exceeding the excel limitation. However, I started removing one sheet at a time as a test and report ran fine after removing 3 sheets. So maybe is it an excel limit issue? IT doesn't feel comfortable trying that 4 GB patch. Microsoft® Excel version is Microsoft 365 MSO (Version 2411 Build 16.0.18227.20082) 64-bit. 

Hi Jeff I don't have an update yet but will report back soon. Customer's IT took it over.

The client reported that the report was generated without issue this AM.

She is connected via RDP so perhaps an overnight reboot cleared the issues.  Short-term solution?

@Dana Halpin Any progress?

Is there something in the WATER???  Just received a client email on this exact topic.  Life has been good with SI for over ten years and now this.  Could this be related to this thread?

Microsoft update breaks Excel-Addins (MS Excel 2016 - MSI) | Sage 100

Also, has anyone used the 4Gpatch solution reference in the KB?  Is this it?  4GB Patch – NTCore

Would this memory limitation disappear if a 64 bit version of Excel was being used?

C. 4GB Patch Solution 

Disclaimer:

The solution discussed below is not a Sage product and as such Sage is unable to support it. 

Consider applying the 4GB Patch solution to resolve the above reporting error. 

4GB Patch is a tiny software solution that can help you tweak your x86 programs so that they can make use of up to 4 GB of RAM, when running on a x64 PC. 

Using the 4GB Patch can be used to successfully increase the memory usage in Sage Intelligence's BICore.exe file to run with extra rows. It can therefore reduce the instances where this error impacts reports. 

Please consult with your local IT technician to access and properly install it on your PC. 

When done, you should be able to run large data set reports in Sage Intelligence.

I search KB and nothing like that came up. This is great. Thank you for the resource.

Have you seen this?

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=240130164747270&page=1&position=1&q=240130164747270

Thank you Doug. Very helpful.

This link has ideas on how to optimize Excel to use less memory.

https://learn.microsoft.com/en-us/office/troubleshoot/excel/clean-workbook-less-memory

Still working on this issue. Workstation only had 8 GB ram so we decided to try report on a workstation with 32 GB of ram and same error. Report has 10 sheets and the max rows on a sheet is 270,000 so it's not exceeding the excel limitation. However, I started removing one sheet at a time as a test and report ran fine after removing 3 sheets. So maybe is it an excel limit issue? IT doesn't feel comfortable trying that 4 GB patch. Microsoft® Excel version is Microsoft 365 MSO (Version 2411 Build 16.0.18227.20082) 64-bit. 

Hi Jeff I don't have an update yet but will report back soon. Customer's IT took it over.

The client reported that the report was generated without issue this AM.

She is connected via RDP so perhaps an overnight reboot cleared the issues.  Short-term solution?

@Dana Halpin Any progress?

Is there something in the WATER???  Just received a client email on this exact topic.  Life has been good with SI for over ten years and now this.  Could this be related to this thread?

Microsoft update breaks Excel-Addins (MS Excel 2016 - MSI) | Sage 100

Also, has anyone used the 4Gpatch solution reference in the KB?  Is this it?  4GB Patch – NTCore

Would this memory limitation disappear if a 64 bit version of Excel was being used?

C. 4GB Patch Solution 

Disclaimer:

The solution discussed below is not a Sage product and as such Sage is unable to support it. 

Consider applying the 4GB Patch solution to resolve the above reporting error. 

4GB Patch is a tiny software solution that can help you tweak your x86 programs so that they can make use of up to 4 GB of RAM, when running on a x64 PC. 

Using the 4GB Patch can be used to successfully increase the memory usage in Sage Intelligence's BICore.exe file to run with extra rows. It can therefore reduce the instances where this error impacts reports. 

Please consult with your local IT technician to access and properly install it on your PC. 

When done, you should be able to run large data set reports in Sage Intelligence.

I search KB and nothing like that came up. This is great. Thank you for the resource.

Have you seen this?

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=240130164747270&page=1&position=1&q=240130164747270