Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

excel

  1. M

    viewing Excel tables in Numbers

    Greetings. I have encountered the following problem: exel table created on a Windows computer and opened on a Mac via Numbers works incorrectly. That is, the table works fine, the folded rows are unfolded, but the problem is not really in them, but in the images attached to each row. They are...
  2. Apple Knowledge Navigator

    All iPads Can you recommend an iPad for me? Note-taking in Excel

    I'm looking to buy an iPad for my job (personal trainer at a gym), where I frequently make notes. To date, I've printed a programme card and made hand-written notes on printed paper for every session. So as you can imagine, not only do I got through a lot of paper, but it mostly gets wasted as...
  3. D

    After a Sequoia update, has anyone else had to manually set Word and Excel as the default apps for opening .docx and .xlsx files?

    As per the subject line; neither Word nor Excel were recognised as standard apps for these file types and I had to do it manually (and against the advice that it wasn't known that these apps would open these files). I have had to do this on more than one machine, both with Intel (i7) and Mac...
  4. elads

    Office for MAC

    Don't ask why but I'm using Office on my mini MAC. Apart from the fact that it is full of bugs there is a really annoying issue with hyperlinks embedded in office file I was hoping someone could help me overcome. I am using hyperlinks of mp4 files etc in my word and excel files. Those mp4 files...
  5. O

    need help with excel for mac

    Hello, I have 2 questions about excel for mac. 1) I want to assign a keyboard shortcut for the litte downward triangle button next to the font color button (shown on the left side of the attached photo). I want to hit a certain keystroke and bring out the color palette as shown in the...
  6. U

    pivot table average of sums.

    Is it possible to add a column to a pivot table that shows an average of the sums. I'm trying to calculate an average spend per category per month. I'd like "Grand Total" to instead display an average of each month's sum for each category. Picture attached for context. Thanks
  7. luzsa2004

    iPad Classic Menu in Excel 365 on iPad?

    When using Excel 365 on the iPad, how to toggle to view the classic menu across the top that includes data validation? Attached is what’s visible and it’s limited across that menu. TIA.
  8. M

    Excel is crashing after saving in network drive (SMB) - Ventura

    Hello, I have BIG problem after updating to macOS Ventura. When I try to save changes to an excel file located in a network location (SMB) I get the message - " The document was saved successfully, but Excel cannot re-open it because of a sharing violation. Please Close the document and try to...
  9. victor64500

    MS Office toolbar submenus not clickable in Ventura, thoughts?

    Hi, It works with up and down arrows but not with mouse or trackpad. I've Ventura ß7 and tried MS Office ß but no change. Did a clean install of MS Office. No change. Did a safe mode reboot. No change. Any thoughts ? Thanks. Victor
  10. StlCards80

    2016 MBP TB 8G RAM 2,9GHz Processor - Upgrade to 14" MBP

    I've got a 2016 13" MBP TB with 8g RAM and 2.9GHz dual-core intel 5. I just looked at the new 14" MBP, and with RAM and processor upgrades I'm looking at $4 grand. YIKES! I paid $1,600 for this one 6 years ago. For anyone in the same boat that has upgraded, was it that impressive? For...
  11. M

    Custom function key treatment

    This may not be possible, but I'm checking to see if anyone knows of a way to utilize the mac function keys as they are setup by default (so they would adjust brightness, volume, etc.) but to treat them as standard function keys for specified apps (primarily excel). I know I can override the...
  12. H

    Help - Spinning wheel with Excel out of control

    I have an issue which has now gotten so bad as to make Excel very difficult to use at all. I had High Sierra and a much earlier version of Office running and every now and then I would get the spinning wheel. It was a bit annoying, so finally bit the bullet and upgraded to Catalina (iMac can't...
  13. F

    iPad Pro iPad 11 Pro 2021

    I just purchased an 11” 2021 iPad Pro. So far so great! I really like the small form factor. A couple of things I wished it did differently: 1. Give me full access to Excel. Let me have CSV files and the ability to unlock locked worksheets. 2. Salesforce sucks on iPad. The app is trash and...
  14. H

    M1 Praises from an Accountant

    I just switched jobs, and when I learned that my new company supports Macs, I was very tempted to switch. I've used Windows professionally for 10+ years as an accountant (controller), and am very fast with shortcuts in excel. I was so disappointed with my work PCs (last one was only 1 year old...
  15. Q

    Help w/Excel macro "Syntax error"

    A macro made in Excel on a Windows machine isn't working on my mac. Below is the section it's getting hung up on and giving me a syntax error. Trying to figure out what I could do to make this work. I'm guessing it's the filename designation. Frankly, I don't care where it gets saved on my mac...
  16. T

    Excel much slower switching tabs by mouse click (~1.5 sec delay) than by keyboard shortcut

    I'm wondering if anyone else has experienced this. I've only noticed it with Excel 365 for Mac; I've not encountered it with Excel 365 for Windows. I find Excel responds frustratingly slowly when I try switching to a new tab by clicking on it. I've timed it, and the delay is ~1.5 s. That...
  17. D

    Excel running slow on new MBP 13' 2020 (i5 10th gen/16gb/512gb)

    Hello everyone, I have just bought my first MBP (i5 10th gen/16gb/512gb). Today I was working with a relatively large dataset. And I used an INDEX/MATCH array function to re-organize my dataset. When dragging down the formula with "cmd + D" the MBP takes AGES to load, it has been calculating...
  18. view60

    macOS VBA Pathfinder

    I have to call a file in VBA and I'm struggling.
  19. M

    iPad How is Microsoft Office on the base iPad? Is it any different from the desktop version (Windows)?

    I'm thinking of getting a new iPad and the main programs that I want to run is MS Office - Word, PowerPoint, and Excel. Is the iPadOS version of Word, Excel, and PowerPoint any different from the desktop version (Windows) and what do you get with the Office 365 subscription? Thanks in advance...
  20. keithhurley

    Excel for Mac protected file

    My first post, please be gentle...sorry if this is in the wrong forum! Today a student presented me with an issue I haven't come across before - he was sent an Excel file which has password protection enabled on the worksheets (the file is not password protected, just the worksheets within the...