Excel On Steroids - Excel Issues (219)

Discussions Replies Latest Activity

Excel Question for a Combined report

I have hit a blank and would appreciate any wisdom or idea's. I have drawn three separate reports and created a union report and on the rep…

Started by Meg McDonald

3 Oct 16, 2018
Reply by Jim Smith

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

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

Sage Intelligence and Microsoft PowerBI

Hi all. For those of you who would like to leverage Microsoft PowerBI as the front end for your reporting in addition to Excel, join me fo…

Started by Peter Scully

11 Aug 23, 2016
Reply by Peter Scully

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

How to hide all sheet except One Sheet

I would like to make a report and want to operate multiple sheets with one panel sheet, all should be hide when I am on panel sheet I can m…

Started by Sajjad Zaidi

2 Feb 17, 2016
Reply by Sajjad Zaidi

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


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service