Excel On Steroids - Excel Issues (249)

Discussions Replies Latest Activity

Pivot Table Issue on saving as a template in Alchemex

I have data beginning pulled from multiple datasets into Sheet1 and I can successfully create a Pivot table from the data. By default the p…

Started by Reinhard Erb

16 Apr 26, 2018
Reply by Peter Scully

Excel 2016 PivotTable - Saving with Groupings

I have a report that is working great. I have invoices being grouped by Year / Quarter / Month.  It automatically happens when I first bui…

Started by Benton Bolt

13 Mar 7, 2018
Reply by Lisa Dion

Sumifs - not working with Table reference

Hi,  SUMIFS(Table1[[#All],[MonthlyAmount]],Table1[[#All],[Rollup_1_SubCode]],$D15,Table1[[#All],[CostingGroup]],$F15,Table1[[#All],[Fiscal…

Started by Shwu Hua Gan

3 Feb 14, 2018
Reply by Peter Scully

Excel Versions

Hi everyone!  Can someone please tell me what versions of Excel Sage Intelligence works with?  This would pertain to all Software types. I…

Started by thereportstore.com

1 May 15, 2017
Reply by NATE

Date/Decimal to Year and Month

I need to get from a date or decimal to amount of years and months worked.  For example, if I have a decimal value of 0.5 I want to show th…

Started by Nevashnee David

3 Apr 28, 2017
Reply by Shwu Hua Gan

Pastel has determined that you do not have the required Microsoft package installed.

When we are trying to export a file to excel we get this error. It work fine , and all of the sudden now it gives this error. Pastel has de…

Started by Maralieze Morris

2 Sep 6, 2016
Reply by Maralieze Morris

Excel 2010 Record Macro in Pivot Table "Run-time-error '1004'"

Running Excel 2010. Have a Pivot Table that I want to use a Macro to Filter a value. I start the recording click on the field filer - s…

Started by Doug Walker

8 Jul 24, 2016
Reply by Peter Scully

lookup dates to find exchange rate in excel

Hi All, Bound to be a whizz that can answer this easily and am time-pressed and no manuals here so heres hoping..   I have a workbook where…

Started by Sue Henderson

2 Jun 5, 2016
Reply by Harrison Delfino

excel views won't display

I have an excel workbook and I created three different views of one of the sheets. The workbook have 10 sheets. None of the workbook or the…

Started by Dirk

4 Nov 13, 2015
Reply by Edwin

Problem in Excel trick "3 easy steps to display the date difference in years, months and days in Excel"

I have checked the results of 3rd,4th & 5th dates the results of 3rd and 5th dates are not coming correct, the problem is in days. In 3…

Started by Vimal Mishra

1 Nov 12, 2015
Reply by Peter Scully


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service