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...
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...
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...
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
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
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...
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
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...
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...
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...
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...
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...
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...
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
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.
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
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...