Posts by sophie619

    Yes, I am glad both sites are still up and running!! :)

    Big props to all you who answer questions for those like me who are in and out.

    My only purpose for mention Chip's site was this: Chip's CellView is the only one that shows up on my Add-ins tab, but even though both that and the File Size one should be in that tab, CellView is the only one that is visible.

    Thanks for all the input


    One of the other add-ins I have is CellView from Chip Pearson, and that indeed shows up on the Add-ins tab.

    I thought the File Size Reducer was from this site (but it was free when I got it), which is why I was asking here if anyone knew.

    It's "File Size Reducer" :)

    The file name is:

    File Size Reducer.xla

    The accompanying text file is called fsr.txt and has general instructions on how to use an add-in and then a blurb about this particular one. I'll paste it below:


    Installing Any Excel Add-in


    1: Save the *.xla to your hard drive. This will be a spare, so keep it in a safe place!

    2: Again save a copy to C:\WINDOWS\Application Data\Microsoft\AddIns\ .

    If not any location, just take note of it for step 4.

    3: Open any Workbook.

    4: On the Tools menu, point to Add-Ins and click Browse.

    Locate your add-in, select it and then click OK.

    5: Ensure your add-in is in the Add-ins available: box and it is checked.

    6: Now click OK and your add-in is installed.

    Look for "File Clean" on the Worksheet Menu Bar. Keep in mind that only workbooks that have increased unrealistically will be reduced in size.


    Thanks! I do have a couple of tricks I want to try (that being one of them), but I thought since I already had this and it's installed (According to my "File > Options > Add-Ins > Active Application Add-Ins" section) that it would be another tool I could use (If I can find it).

    Hi all,

    I recently remembered I had an old version of the File Size Reducer that I downloaded years ago. I have a workbook (or 3...) I want to try it on, but I can't remember where it actually places the "File Clean" on the ribbon. The old text file I have says it will be under the "Worksheet Menu Bar".

    Does anyone know/remember?


    Re: Recent Workbooks - when last saved?

    Quote from cytop;751082

    You're right - it's not natively possible in Exce, but there is code on the board which will retrun a list of files in Folders (and Subfolders if needed). That list can then be added to a worksheet (for example, it's the easiest option), the date/time last modified added and then sorted by date ascending/descending...

    If you can be a little more specific about what you want, it may be possible to work this.

    That gives me an idea - if MS has a specific folder where they keep pointers to the "recent workbooks" on the list. Hmm, I will see what I can find. Thanks!

    Re: Recent Workbooks - when last saved?

    Quote from mohammedismail;751067

    I'm not sure what you are asking is available in Excel but What probably you can do is, in the folder where you have files saved, arrange the files based on Last modified so that the last edited file will be the first/Last file. Does that make sense ?

    I understand what you are saying, but different ones are housed in various folders, so that won't necessarily help.

    But thank you for responding! Like I said, it may not actually be possible in Excel, but I was trying to see if there was a solution out there that I was missing. :)

    Re: Recent Workbooks - when last saved?

    Quote from mohammedismail;751054

    You can see the Excel file properties to check when it was last modified/accessed ?

    Do you mean open one file, check the properties? I was trying to avoid opening all of them, just wanted to open the most recently updated one.

    If you didn't mean that, I don't think I understand. I don't see how to see the properties from the "File - Open" screen. Right clicking only gives the following options:
    Open/Open a Copy/Copy path to clipboard/Pin to list/Remove from List/Clear Unpinned Workbooks

    I'm looking for a way to see when the workbook in "Recent Workbooks" (File - Open - list of recent workbooks) was last saved.

    I have a few workbooks that are updated not daily, but with great frequency, and I'm wondering if there is a way to make sure I open the one with the latest date. These workbooks rotate around on a shared drive, and it's possible that two people can be making changes if one saves it after downloading to their maching and then uploading again to the server. While I realize this is a totally different problem (for which I tend to use workbook compare), I'm wondering if there is a way to make Excel display the "Date Modified" portion on the Recent Workbooks page.

    My google search came up empty. And it's entirely possible that MS didn't include this feature, but it would be super helpful to me.


    Re: Adding an appointment to Outlook from Excel with VBA

    What happens if you don't know where the folder is in the file structure?

    Someone has given me permission to view their calendar with full access. When I click on Calendar on the bottom left of Outlook (Mail, Calendar, Contacts, Tasks), on the left toolbar there is my calendar, and then a bunch of others I've put in folders. But I don't know how that file structure fits in to the one that opens with your GetOutlookFolderID() (thanks, btw!). Any idea how to get that information if that calendar is active?


    PS - admins, let me know if I need to start a new thread for this. I will do so if needed. Thanks!

    Re: Creating multiple series chart without hand selecting each dataset

    I've written some rough pseudo code, maybe someone can help me turn this into a macro?

    I'm trying to capture x data and y data for each series in an array, so that I can use the SERIES function to graph them.

    Here's the code:

    for each row in column A <> empty
       for i=1 to 100
          if (row in column A) = i
             xsubi=xsubi+B(row) (this needs to be an array that can grow.  Do I need to know how big it can possibly get, or is it possible to create this dynamically?)
             ysubi=ysubi+C(row) (same as above)
             go to next row
          end if
       end for i
       go to next row
    end for

    Re: Creating multiple series chart without hand selecting each dataset

    I would like all 4 series (j,k,l,m) on the same chart. The line for series "j" would have three points (3,9), (4,4), and (45,2).

    This is just a made-up sample, as I can't upload the actual data.

    I was hoping there was a way to select the series by using a function rather than using the mouse to select the cells on the worksheet by hand.

    Re: Creating multiple series chart without hand selecting each dataset

    Quote from PCI;681223

    How do you want to you select the series to put in the same chart?
    What means "I'd like to plot (3,9) "

    I'd like to have the chart be a regular graph of x vs y, where the x point is 3 and the y point is 9 (as is displayed in the first row of the attached workbook).

    Does that help?

    First time poster here, but I've checked out the cross posting info and hope am doing it correctly. Please let me know if I'm not doing it the correct way, and I will try my best to correct it. I didn't get any replies in the other forum.

    Original thread link:…tml?p=3377894#post3377894
    Please post replies at the original link, or if you are not registered, let me know and I will post it there and mark both of them solved.

    I've been working in Excel for awhile, but not with such large datasets. I'm starting to learn VBA also, but was looking to do this without it, if possible. After searching google, I don't think it's possible, but maybe you all can help me.

    Is there an easy way to create a chart with multiple series, but not actually put each of the series in manually?

    The problem is that I have 2 columns that I want to plot, but each series could be 1 point or many points. Each series is represented in the example workbook by a letter (j,k,m,n) and then I'd like to plot (3,9) as if it were an (x,y) pair.

    The reason I would like to not select all these by hand is that there are about 100 different series (which I would not put all on the same graph) and I'm going to have to do this on multiple spreadsheets for different data sets.

    Thanks in advance!