• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. mdfreeman

    On Open: Check Excel 365 file for AutoSave status. If "On" / "Turn Off"

    Hi! Goal - open file that is on SharePoint and ensure that even those with permission to change file, do not mistakenly "Auto-Save" over the original file. I have pulled together code that works to check if a file is set to "Auto-Save" in o365 that works. Now I have placed in into an "On...
  2. mdfreeman

    PowerPivot Custom Sort not working

    Hi All, Trying to get a PowerPivot table to sort on a custom series. The PPT is setup to allow I have setup under PPT options / Totals & Filters to "Use Custom Lists when sorting". Going through the menus and what I would do with a regular pivot table is not working. See images. Does anyone...
  3. mdfreeman

    Multiple PDF to one excel workbook

    I am reading this as you want the IMAGE and not necessary the data to be loaded to each workbook. Do I have that right? If so.... I did something like this a while back and saved the macros to my personal workbook. Steps: 1. Convert the PDFs to Image files (I believe I used TIF). If the...
  4. mdfreeman

    Extract summary data from multiples spreadsheets

    Is it a job for PowerQuery to normalize any data and then merge the data from each sheet together?
  5. mdfreeman

    Consolidating Multiple workbook in to one sheet

    If this is a regular thing you are doing check on the resources on this page along with the addin that Ron de Bruin has created. Coding resources: https://www.rondebruin.nl/win/section3.htm Addin: https://www.rondebruin.nl/win/addins/rdbmerge.htm Mark
  6. mdfreeman

    Excel/Mail Merge/Convert to PDF and Send email

    Hey @Damir The best resources for this are from Ron de Bruin Page here: Mail from Excel and make/mail PDF files - https://www.rondebruin.nl/win/section1.htm I suggest working with the addin he has created: Mail Add-ins for Excel for Windows. It is a great tool! Mark
  7. mdfreeman

    Select next Item in SlicerCaches for pivot table

    Excellent! Thank you! Works like a charm! Simple and easy So what is the "pi.RecordCount >0" loop change? Digging around I found a little more information about PivotItems with zero record count - This page was the best: Why Excel 2003 keeps PivotItems with zero record count after refresh...
  8. mdfreeman

    Select next Item in SlicerCaches for pivot table

    Thanks for taking a looking / spreadsheet attached. I had to strip down the data to allow for the upload so the macro now breaks on the 1st loop with the same error. Macro is Pivot_PageFields_Looping
  9. mdfreeman

    Select next Item in SlicerCaches for pivot table

    I am closer to the code I think will do the trick without a dictionary of items I want to filter on. I like the loop to stop at each item that has data in the pivot table, from there I'll add code to work with that data before looping. The problem. I am running into Run-time error "5". Invalid...
  10. mdfreeman

    Select next Item in SlicerCaches for pivot table

    Hey @Chihiro: I am not familiar with setting up an OLAP data model in Excel. My data source is not currently an OLAP model. My Google search are not coming up with useful information. What should I be searching on? VisibleSlicerItemsList: Am I achieving the same results when I have adjusted...
  11. mdfreeman

    Select next Item in SlicerCaches for pivot table

    Hey @jeffreyweir : I like you idea. Yes! Thank you. Using PageFields to cycling through my choices is a better option than that Slicer approach since I don't have to start each new loop by clearing the filters on the Slicer to get to the next item to filter on. One downside: There are...
  12. mdfreeman

    Select next Item in SlicerCaches for pivot table

    Hey! I am looking for a more efficient way to have my VBA roll through a list of items in a SlicerCache. Current wisdom of the internet below results in repeated resetting of the filtered SlicerItems looping over and over again to get to each item. It is very inefficient when your list of...
  13. mdfreeman

    Compare and Merge - many workbooks to the source #fail

    I am using the Compare and Merge function in Excel 2010 just like it is described on this page: https://office.microsoft.com/en-ca/excel-help/merge-copies-of-a-shared-workbook-HP010177169.aspx The issue is that I cannot merge more than one file at a time into the original shared file as per the...
  14. mdfreeman

    Shared workbook error: Problems reading or applying part of revision history

    Hey Excelers, I have successfully use Shared workbooks over the past 8 months with few issues but in the last month I have users and myself run into the following error. "Excel was unable to save the workbook because there was a problem readin or applying part of the revision history. You can...
  15. mdfreeman

    Filter based on string of numbers

    Thank you for taking the time to put the file together. Advanced filters makes perfect sense now. Still, it would be nice to be able to drop multiple items into the simple filters
  16. mdfreeman

    Filter based on string of numbers

    Thank you. Interesting. I have never used this feature. Quick testing of isn't working but I will play more.
  17. mdfreeman

    Filter based on string of numbers

    I am dreaming of being able to paste a string of numbers (separated by commas, semi colons or the pipe) into a standard filter. My simple attempts haven't works. Is it possible? What is the correct deliminator? Thank you in advance for the help.
  18. mdfreeman

    Reset layout of VBA windows

    Ahhhh! A little more thought and google searching and I found this resource all about docking of windows - http://www.jkp-ads.com/articles/VBEDocking.asp
  19. mdfreeman

    Reset layout of VBA windows

    Hey! How can I reset the layout of my VBA windows to the default?
  20. mdfreeman

    Sharing spreadsheets with colleagues

    Hey All, I am looking for the best way to share an excel workbook with a colleagues so we can work on it at the same time. (I wish Excel worked more like Google docs so we could visual work on the file at the same time.) What are the best practices that others are using. Mark PS - is...
Back
Top