Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Filter one column with multiple checkboxes

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Filter one column with multiple checkboxes
Hi excel guru's!! I am in need of some VBA coding that will allow me to filter a specific column with multiple check boxes. For example, I have a worksheet with over 100 rows of data and each row in column B has a month. Can I have check boxes for each month and filter my data based on the...

Excel Help Forum - Excel General: Excel 2010 Slicers

Feed2Mail notification - new post on Excel Help Forum - Excel General
Excel 2010 Slicers
I have 3 different pivot tables on the same sheet. It's an employee commission sheet. The employee sold policies for 3 different products. On the sheet, it has his/her break down laid out in 3 pivot tables. Each different pivot table is for a separate product, and all 3 pivots are based off 3...

Excel IT Pro Discussions Forum: Excel using Processor but not RAM

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel using Processor but not RAM

When we run Excel 2010 x64 (large calculation) it consumes all of the processor 100% but less than 1% of the ram. How can I force (or firmly request) excel to utilize all of the RAM (24GB) that the machine has available. 

If I add another processor - what settings can I manipulate to let excel utilize multi-core processing?

Windows 7 PRO 64bit, 

Thanks,

SJ

Excel Help Forum - Excel Programming / VBA / Macros: Add the similar ID

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Add the similar ID
Hello Everybody I want to add the similar IDs, for the sake of example workbook is attached with this thread.

Excel Help Forum - Excel General: Changing Axis

Feed2Mail notification - new post on Excel Help Forum - Excel General
Changing Axis
If I have information going along the x axis, how can I switch it all to go the other way along the y axis?

Excel IT Pro Discussions Forum: Excel External Data Connection and SharePoint 2010

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel External Data Connection and SharePoint 2010
I've recently installed SharePoint 2010 and TFS 2010.  I've setup the Secure Service Store but find an issue when working with the external data connection in Excel 2007.  The only authentication methods are Windows, SSO and None.  I don't see an option to use SSS.  Will it still work the same and go after credentials in the SSS database or will it look specifically for an SSO database.

Office IT Pro General Discussions Forum: Outlook 2010 - Quick Steps Limit

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Outlook 2010 - Quick Steps Limit

Hi

Does anybody know if there is a limit to the number of Quick Steps you can create in Outlook 2010?

Thanks, Viv

Viv Haig

Subscribe to: Comments (Atom)