Excel On Steroids - Excel Issues (217)
| Discussions | Replies | Latest Activity |
|---|---|---|
 Pivot tables not refreshing automaticallyHow do I get a pivot table to automatically refresh each time data on a source worksheet changes without having to close and reopen the spr… Started by Eric Pika |
4 |
on Friday Reply by Eric Pika |
Selecting Top 10 items in pivot tableI have attached a file with sample data. Real sales data has been extracted using Alchemex. In the pivot report I want to show the top 5… Started by Michael Bass |
2 |
on Thursday Reply by Michael Bass |
Code and description rows in pivot tablesis it possible to add a code and description to an excel pivot table without having the two stacking. I want them to be on the same row. I… Started by Eric Pika |
4 |
Apr 25 Reply by Eric Pika |
Pivot Table SortingHi, I have a pivot table with this columns: Business Unit Project Name Job Code Qty Values Research Business Zone … Started by Shwu Hua Gan |
1 |
Apr 24 Reply by Edwin |
Using Data Validation - List in Excel 2007Hi, I have a very simple Excel, which I used Data Validation and Set the List of items to select. See Worksheet "Budget Item" in the attach… Started by Shwu Hua Gan |
2 |
Apr 23 Reply by Shwu Hua Gan |
Excel on Steroids - grouping using SUMIFSLes, I viewed the webcast of Session 1, Sage Intelligence Advanced RW Sessions explaining groupings using SUMIFS. I managed the groupings… Started by Michael Bass |
3 |
Apr 10 Reply by Michael Bass |
SQL Expression being interpreted as Date in Excel - How to stop itI have a SQL expression in my container as follows CAST([ICHIST].[TRANSTYPE] AS CHAR(2)) +'-'+ CAST(isnull ([LSADJ].[LSADJTYPE],'') AS CHA… Started by Reinhard Erb |
2 |
Apr 4 Reply by Reinhard Erb |
Pivot Table - Inventory Qty Beginning Balance Running TotalI am trying to create a report and need some help creating a Running Total that starts with a Beginning Balance and adding a Period Change… Started by Doug Walker |
2 |
Mar 30 Reply by Doug Walker |
Problem om an Excel FileI've had this problem a few times already. It seems that my Excel file becomes corrupt. When opening a random excel file that contains f… Started by Elizna Bouwer |
6 |
Mar 28 Reply by JohnD |
dealing with rounding and incorrect totals in pivot tablesIs Excel actually lacking a built-in solution for this, or am I just not aware of it? I have a pivot table showing summed $ values from my… Started by Ralph |
0 | Feb 10 |
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
