community
272 TopicsExcel Chart Copy/Paste Resolution
I create charts in Excel, paste them into Photoshop to add a transparent background, then paste these into my web site. I've been doing this since 1999. Until today, the charts always copy/pasted at 96 dpi. The work flow depended on this. These charts are all sized to fit in the right places. 4" by 5" gave 385 x 481 pixels. They looked good. Hotspots (img maps) on the web page lined up properly with chart elements. Today they paste at 150 dpi which is too large. 4"x5" becomes 601 x 751 px. Nothing lines up. Reducing the size in Photoshop gives ugly results. The File>Options>Advanced>Image Size and Quality Default Resolution cannot be changed to 96. It immediately reverts back to High Fidelity. So this idea does not work. I know that I can start all over, but that is a lot of work. How do I set the default chart resolution for copy/paste back to 96 dpi where it was for 27 years and where I need it to be? What did MS change to break this? Windows 11, Microsoft® Excel® for Microsoft 365 MSO (Version 2610 Build 16.0.20527.20150) 64-bitSolved142Views0likes4CommentsFill in a cell based on an answer from another range
As a General Contractor I am reviewing subcontractors/pricing... I have a list of prices in Row1 and a list of Contractor Names in Row2 I have a separate tab showing lowest price per trade. I use 'min(row1)' to determine which price is lowest and put it in my final sheet. At this point, I want to list the name of the contractor that has the lowest price. If I use min(row1) to find the lowest price, how do I set up the next cell to list the name of the lowest priced contractors?305Views0likes5CommentsCan't edit cells in Excel 2010 since Sept 2026 patch Tuesday
I can't edit cells in Excel 2010 spreadsheets since Sept 2026 patch Tuesday. How do I reverse this back to the former working software. There was one comment that said it might be caused by a Windows 10 security update. Since Windows 10 isn't supposed to get security updates anymore, how can that be an issue? Ron181Views0likes2CommentsExcel Nested Arrays: Find the Nesting Depth of Uniform and Ragged Arrays ARRDEPTH() & ISRAGGED()
Hey everyone! I’ve been diving deep into Excel’s new nested arrays features lately, and I absolutely love the flexibility they bring to data structuring. However, managing them can get a bit tricky, so I figured I’d build some specialized tools to handle them seamlessly. Public Interfaces & Arguments =ISRAGGED(array) Argument Description Default Behavior array Target nested structure to validate. Required =ARRDEPTH(array, [is_ragged]) Argument Description Default Behavior array Target nested structure to measure. Required [is_ragged] TRUE: Scans all branches for the deepest path. FALSE: Speed test on the first path only. FALSE (Omitted) TL;DR (What makes it tick): Function Name Type What It Does ARRDEPTH Public UI Returns nesting depth. Supports deep checking or fast linear testing. ISRAGGED Public UI Structural validator. Returns TRUE if array branches have uneven nesting. ANALYZE_NESTING Hidden Core Engine Multi-process recursive parser that tracks tree structure geometries. LINEARDEPTH Hidden Utility High-speed depth checker that evaluates the first element path exclusively. You can get both functions from my GitHub Gist: https://gist.github.com/Medohh2120/9cdf939036942c9672c57ccd6de696d3661Views1like9CommentsFeature Request: Repeat Rows at Bottom of Printed Pages
Excel currently supports "Rows to repeat at top" (Print Titles), but there is no equivalent feature for repeating rows at the bottom of every printed page. This would be useful for stocktaking sheets, picking lists, audit forms, inspection records and other printed worksheets where users need space for handwritten additions or notes. Proposed enhancement: Add a "Rows to repeat at bottom" option in Page Setup, similar to the existing "Rows to repeat at top" setting. The specified rows would be printed at the bottom of every page, regardless of sheet length or filtering. My current use case is stocktake reports generated from Power Query where counters need 3-5 blank lines at the bottom of every printed page to record items not listed.249Views0likes2CommentsExcel external workbook links break across users (using cloud storage)
We use Excel desktop on Windows computers with Microsoft 365. Our office uses Sync.com to synchronize shared client files across multiple employees' computers. Our current setup: We have a Master Excel workbook linked to approximately 11 individual client workbooks. We create new workbooks and establish the links twice a year, in June and December. We create links by opening both workbooks, selecting a cell in the Master, typing =, switching to the individual workbook, clicking the source cell, and pressing Enter. We need linked values to update automatically when both workbooks are open. Our folder structure is: - Master: Sync\1 - CLIENT FILES\Equitable Block\Block Name\Renewals\YYYY - Individual workbooks: Sync\1 - CLIENT FILES\Client Folder\Renewals\YYYY The files are synchronized through Sync.com, and everyone opens them from shortcuts to the shared Sync folder. The problem: Excel stores an absolute local path in the formula. For example: C:\Users\paige_lnsp4p\Documents\Sync\1 - CLIENT FILES\...\[Individual Workbook.xlsx]Myers Position'!$F$16 Another employee's Sync folder is located at: C:\Users\chris\Sync\1 - CLIENT FILES\... As a result, links created by one employee work on that employee's computer but fail on others. Changing the source to the local path on another computer repairs the link there, but that is not a practical permanent solution for our team. Sync.com support confirmed that its desktop app cannot enforce a consistent local path across different Windows usernames. They suggested investigating relative Excel links. My questions: 1. Can Excel desktop create and maintain relative external workbook links that work across multiple Windows computers when the shared folder structure is identical but the local root paths differ? 2. Given that the Master and individual workbooks are stored in different branches under Sync\1 - CLIENT FILES, is there a supported way to achieve this without moving all workbooks into one folder? 3. If relative links are not supported for this arrangement, is there another reliable way to maintain these links without requiring each employee to change the source paths? 4. Would VBA or another Excel-based solution be appropriate, or would it introduce further reliability or security issues? We want to preserve our existing workbook design and continue using desktop Excel. We are looking for a permanent solution that works for all employees, not a process that requires manually repairing links on each computer.130Views0likes1CommentLong Date Format Text Wrapping
I need my dates to be in the long date format: Monday, December 8, 2025 However, I also want that text to wrap. I do not want an really wide column for that date. I would like it to wrap at whatever point it wrap at when I adjust the column width. Simply choosing "wrap text" in the alignment section does not work. Any column width shorter than the amount of space needed for the entire date turns the date in that cell to pound signs. Heck, I'd be happy if I could even just shorten the column width and see only the beginning of the date. Though I would prefer it just adjusting like it does in every other column. I have tried work arounds like a custom date format where you force the second line to be part of the date - which it will do but the column width still must be as long as if it were in one long line or it still goes to pound signs. Is there a workaround that I can't find? Is this something that Microsoft could work on fixing in an upcoming app update? Because I have been suffering through this problem for years and would love for it to be fixed. (Also - I do not want to change the column to "text" - I want to be able to type in 12/9 and have it automatically change to Tuesday, December 9, 2025 for me. I am often changing dates or inserting dates and need it to be dynamic and not manually entered each time. (Thus the whole point of having the date format to begin with.)713Views0likes3CommentsAfter seven years of being helped and even offering some help to others ...
... I think AI has effectively put this site out of business. So although I'll check in a few more times over the next month or so, and will definitely miss the virtual friends (real people) I've met, with whom I've exchanged messages...but other than that, it's a sad farewell. Thanks for the memories.374Views6likes6CommentsAdd-in not working in EXCEL 2024 HOME SUBSCRIPTION.
I have office home 2024 subscription. Recently, when I try to add an add-in from the add-in tab in excel it shows error. It was working fine. I had python and some other add-ins through the add-in menu. Can somebody help? I have tried all methods suggested by AI tools.115Views0likes0Comments