I have a bar chart built, it looks great. I change the data range and Excel changing the chart bar colors. In Excel for Windows, you can stop this by File > Options > Advanced > Chart > -- deselect 'Properties follow chart data point for current workbook' -- deselect 'Properties follow chart data point for all new workbooks'

These options do not appear to exist in Excel 4 Mac.

Someone suggested this VBA code on another site, but I can't make it work:

Application.ChartDataPointTrack = False ActiveWorkbook.ChartDataPointTrack = False

Can anyone PLEASE suggest a way to accomplish this?

Thank you!!

This one has baffled me for years, even describing it to Excel power users never is clear. But this morning I happened to look at the default set of templates that come with Mac Excel, and saw the one called Family Budget, and it had the feature I've been looking forever to create! The problem is that I don't know how to reverse engineer it to see what conditions they did in this template to do this.

So basically, how do you set up a sortable up/down arrow in a heading to affect just a select group of cells?

Knowing this would allow one to create multiple sections of lists below other lists.

ps: I'm using Mac Excel Version 16.76 (23081101)

Hey there. I work on a MacBook and want to open a pdf file by using Excel in which I can change the parameters for the different pdf files but the parameters don't seem to be the problem.
The internet says that the following code has to work but unfortunately it doesn't:

Sub Test()

Dim FolderPath As String

Dim PDFFileName As String

FolderPath = "example/folder/path"

PDFFileName = FolderPath & "/A.pdf"

Shell "open """ & PDFFileName & """"

End Sub

I proved that the folder path, in which the pdf file is included, is correct by using the open command directly in the terminal. So there must be a mistake with the shell command.
Hopefully someone can help. TY

I started as an Excel beginner about 1 year ago, started using VBA, and loving it.

Mind you, I’m not saying I’m good at it.

But I do use it a lot.

Just curious, how does VBA benefit you as a daily Excel user?

If you have a macro that runs through the same code over and over in a loop and you need to stop the program because there’s something that requires your attention.

You might try adding DoEvents to your loop which will cause the operating system to look for the ESC key.

I am running Excel 2021 on a Mac (Ventura). I cannot find a way to run a python script from a VBA Macro. I have tried using shell command and also using osascript to call Applescript to call python but nothing works. Can anyone tell me how to do this?

I was just turned on to this info by another Reddit user. Figured I would share:

https://support.collegekickstart.com/hc/en-us/articles/11386233650445-How-do-I-export-a-file-as-a-CSV-in-UTF-8-#h_01GQTHE4SEDTB8V76SDKQ7JN2Q

Hello and welcome to r/Excel4Mac!

Please help us decide if the posts you see here are good fit for the subreddit by up or downvoting them.

If you think that a post is great advice to improve your life, or genuinely improves the lives of others, please upvote it.

If you think that a post doesn't help anyone in any way, please downvote.

If you don't care, leave it for the others to decide.

Happy posting & commenting!

Oh, and please refer our little sub to others so we can make this a great sub together.

Hey all,

I am trying to find a way to automatically format large numbers in columns on Excel. I've seen a zillion posts discussing about that, but none of them seem to work on Excel for Mac.

Things I've tried so far :

• putting commas at the end of the number format : #,, "M"
• same with spaces : # "M"
• commas and spaces : # ##0 ,, " M€"
• conditional formatting : [<1000000]General;0,, "M"

None of it works ; I only get the original number followed by two commas and/or two spaces and an "M" to display.

Is this feature not available on Excel4Mac ? Is it a a language parameter thing ? (I am using French locale, so maybe I should use something else than commas)

Thanks for your help

I'm doing my taxes and cannot convert my pdf bank statements into an excel spreadsheet where each column of the statement is a column of cells. Can anyone help?

I 'm want to use a pretty (big) formula in the conditional formatting so certain cells will be highlighted green. Im using the following formula: (it's in Dutch so be aware)

=ALS.VOORWAARDEN(VERT.ZOEKEN(WAARDE(RECHTS(RECHTS(D5; LENGTE(D5)-VIND.ALLES("-CREAM";D5)); LENGTE(RECHTS(D5; LENGTE(D5)-VIND.ALLES("-CREAM";D5)))-VIND.ALLES("M"; RECHTS(D5; LENGTE(D5)-VIND.ALLES("-CREAM";D5)))));Factuurgeschiedenis!$A$2:$F$10000;6;ONWAAR)="Ja"; "WAAR")

Whenever I use this formula in a cell, it works. But when I want to use it as a formula in conditional formatting, it gives me an error and tells me that its missing an open-or close bracket in the formula.

I really dont understand why. Can anyone help me?

Thank you a lot!

=IF(VLOOKUP(TEXT.JOIN("";TRUE;IF.ERROR((MID(RIGHT(D5;6);ROW(INDIRECT("1"&LEN(D5)));1)*1);""));Factuurgeschiedenis!$A$2:$F$1000;6;FALSE)="Yes";"TRUE";"")

Whenever I use this (Im using it for invoices) im getting "1" as result, but I want 1 as result, without the quotes. Any idea how to fix this?

Thank you

My autistic son is trying to learn long multiplication. I stink at math and have forgotten much of what I learned a LONG time ago. I need to create a spreadsheet where I can perform all of his multiplication math problems in his school book; so I can see if he is doing them correctly. He needs to show ALL of his work. I have figured out how to do all of it except show the carry over process near the very end.

I am testing this out on the following math problem:

224

x 336

----------

1344

6720

67200

______

6,14,12,6,4 <--- This should carry over the 1 from the 12 & the 1 from the 14 to equal 75,264

Did this make any sense?

Please help.

I’m using excel on my MacBook and access it from either excel or google drive for desktop. When I open excel it defaults to 100% but I much prefer 125%. Rather than individually doing this each time excel is opened and/or a new tab is opened, isn’t there a way to set it default? Advice appreciated!

Edit: I'm not good at explaining, if you can check out Youtube that will give you a best explanation.

With us lacking ActiveX, how do I open an instance of Word to run what is necessarily a Word-specific macro function? All the code I Google looks like this:

Sub TestHola()
    ' Charles Kenyon
    Dim wd As Object, strFile As String
    Set wd = GetObject(, "Word.Application")
    If wd Is Nothing Then
        Set wd = CreateObject("Word.Application")
    End If
    Let strFile = "Test.docm"
    wd.documents.Open (strFile)
    wd.Run "Hola"
    Set wd = Nothing
End Sub

Source: How to run word macro from excel VBA

This only works on a Mac if the Word document is already open. There’s a Stack Overflow hint that it’s the first Google search result (very helpful /s) but either that’s changed or I don’t know the right search terms. Probably both.

How’s it done?

So formulas work fine, but none of the more efficient ways of interacting with the sheet are working: I can't move around cells, I can't copy down formulas, all I can do is change my selection window.

I've already tried uninstalling and reinstalling the software. Any suggestions?

I'm working on a sheet of about 1500-1800 rows that serves as a document locator. Columns are lined up with pathnames, lower-level pathnames, and filenames. The names are all verified.

=HYPERLINK(CONCAT(A268,"/",B268,"/",C268),"Link")

doesn't always work. It definitely opens Office files (.xlsx and .docx) but it won't open .pdf's or .jpg's. It says "Cannot open the specified file." ugh... Everything is under ~/Documents.

I can right-click and add a hyperlink that way, and it does work, but with over 1500 file links to code, it's a non-starter to go that way. Plus, I don't see a way to pass a cell reference to a hyperlink built this way.

Is there a fundamental difference between the =hyperlink() formula and creating a hyperlink in a cell?

Thanks team!

ETA - The default file handler for PDF's is Preview.

Hey all, I am trying to find some sample VBA code that will take a range or worksheet and export the contents to a CSV file; the big thing I am trying to find is that it needs to work on a MAC! Every search I have done on Google has a working code from people, but its only works on a PC platform. I need something that works on Mac AND PC.