Forum Discussions (3,734)

Discussions Replies Latest Activity

Changing the data source of multiple pivot tables in one go - Excel 2007

I am copying several pivot tables from Workbook1 to Workbook2. In Workbook 2 the data source of each pivot links back to Workbook1. I want…

Started by Vanessa M in Excel On Steroids - Excel Issues

1 Sep 18, 2009
Reply by Siphiwe Hlatswayo

How do I change the default font & size for new workbooks?

I'd like all new Excel workbooks (and worksheets added to existing workbooks) to default to a font & size (say Arial Narrow 10). How do…

Started by Paul Cleverley in Excel On Steroids - Excel Issues

4 Sep 18, 2009
Reply by Paul Cleverley

Microsoft office Excel has stopped working

Not sure if this Excel or B.I.C. issue... We use Pastel B.I.C.and run both xp and vista operating systems at our company.we use both Excel…

Started by Eban Japes in Sage Pastel Intelligence Reporting

1 Sep 17, 2009
Reply by Fred

Switch Output file to text file

I am currently running my report in Pastel Evolution and it runs out in Excel.Is it possible to change the output of a report into a text f…

Started by Wessel van Diepen in Sage Evolution Intelligence Reporting

3 Sep 17, 2009
Reply by Fred

Stock valuation report question

I am trying to write a stock valuation report on Alchemex from Pastel. How do I pick up the average price of a stock item? Please can someo…

Started by sarah harvey in Alchemex Report Writing

3 Sep 17, 2009
Reply by Fred

Extend Formulae to all the rows in the data

Hi I am trying to use the Add-Ins to copy a formula to all the rows in the sheet. The sheet is called Transactions and the formula is in ro…

Started by Marilize in Sage Pastel Intelligence Reporting

5 Sep 17, 2009
Reply by Fredup

Ostendo Connections

Ostendo is an Add on Solution that works with MYOB and has a Firebird database. There are many views in the database which returns data fro…

Started by Chris Millar in General

3 Sep 17, 2009
Reply by Fred

Grouping in Excel

Hi I am designing a report in alchemex and have drop my data into excel fine. Then I created a pivot table containing in the left column t…

Started by TERENCE FAUL in Alchemex Report Writing

7 Sep 17, 2009
Reply by Fred

Selection is too large error

Hi,I am trying to use the ExtendFormulaToUseRows function and receive this error Selection is too large.Does anyone know what i can do to g…

Started by Raymond "Ray" Krebbs in General

3 Sep 16, 2009
Reply by Fred

editing of pastel report

I Hello,I have a qusetion...In B.I.C. if a client is using Excel 2007 is generating a Pastel report and e-mails it to another member of sta…

Started by sarah harvey in Sage Pastel Intelligence Reporting

1 Sep 16, 2009
Reply by Fred

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service