Forum Widgets
Latest Discussions
Pictures in Cells (excel 2024)
Hello everyone. I am having a problem with excel 2024. I uses windows 11. When I try and insert, pictures, from device (and either in .jpeg or .png file format, the image goes into the cell. I then save the file, butttt next time I open the file I get, "UNKNOWN!" in the cell. Inserting the image into a shape is ok, but won't work as a vlookup in the program. I might even be happy if the darn picture would just stay there. Any ideas would be appreciated. thanks JoeJABMar 18, 2025Copper Contributor36Views0likes4CommentsMissing image when Save as Adobe PDF
Hello everyone, I'm facing a strange issue. I have a quotation, and when I convert it to PDF using the "Save as Adobe PDF" option, our company logo is missing in the PDF file. I tried using both the "Save as" and "Export" functions, but neither worked. I discovered that Adobe PDF is using our printer driver to save as PDF instead of the Adobe PDF printer. Everything works normally when I set the Adobe PDF printer as the default. Here is Office and Adobe version that our employee is usingNamCVHMar 18, 2025Copper Contributor61Views0likes3CommentsPivot Tables
Hello all, For some reason, I cannot create PIVOT tables anymore, and I am not sure why. I am using the online version of Excel, on Microsoft Edge. When trying to pivot my data, it will with show up blank, or not at all. Does anyone know how to fix this issue? Please see attached photos..cnunezMar 18, 2025Copper Contributor97Views0likes4CommentsPivot chart does not read hundredth of seconds from pivot table
Hi, I am kindly requesting for your help. In the attached file you will find in the "Data" tab the raw data with swimmers' styles, swimming distance and time. In "time" column the race time is recorded in m:ss.hh with "hh" being hundredth of a second. You will notice that in the "Dashboard" tab (specifically the chart on the top right titled "No. of races for each style with avg" rounds the time by seconds and does not pick up the decimals. Since hundredth of seconds are extremely important in this exercise, how can I get the chart to pick up the times correctly? Thanks in advance VitoSolvedvitoaiacoMar 18, 2025Brass Contributor27Views0likes2Comments- Guus_1905Mar 18, 2025Copper Contributor50Views0likes2Comments
Excel selects wrong cell
Hello, I am here to report on what seems to be a common issue... After working for a few minutes in excel, when I go to click on a cell, the wrong cell actually gets selected, and it is usually several cells above or below the cell my mouse is hovering over. I sometimes have success in saving, closing and reopening the book, but not always. Excel Office 365 version, updated on schedule, as always.HandFoodlerMar 18, 2025Copper Contributor39KViews4likes24CommentsAmortization Help
So I made a quick simple Amortization calculator to speed up some processes that I do but I've found so small calculation errors. For instance if I wanted it to calculated $7,268.00 over a 24mo term it come up with a payment of $302.83, which is correct, but because the actual payment amount is $302.83333333333 it doesn't calculated the right last payment which should be $302.91 to account for the repeating 3. I've found this is the only time it calculates wrong is just when the payment isn't perfectly round. Is there anyway to fix this? Again the only time I've found it to be wrong is when the payment doesn't calculate out perfectly round.SamM750Mar 17, 2025Copper Contributor33Views0likes1CommentExcel lookup help
Hi, I am trying to work out the formula in excel to look at a column (C12:C23) and if there is the same text more than once only return it once (A15). Then repeat this in A16 but disregard the value that was already returned already in A15 so it doesn't keep repeating. I have a list of descriptions that can be selected via a drop down list (image below C12:C23) and I need to bring them over to another sheet but not double them up if the description has been used more than once. It just keep doubling up. How can I do this? Thanks for any help with this.SolvedRichardLMar 17, 2025Copper Contributor94Views0likes3CommentsI need help setting up a cost / inventory lookup!
I started a sheet to do my inventory and cost association and was able to use the vlookup function to pull the name associated with the item number but not the cost over from a second sheet. Help!!!!!!LepardessMar 17, 2025Occasional Reader26Views0likes2Comments
Resources
Tags
- excel42,398 Topics
- Formulas and Functions24,584 Topics
- Macros and VBA6,375 Topics
- office 3655,981 Topics
- Excel on Mac2,633 Topics
- BI & Data Analysis2,352 Topics
- Excel for web1,901 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,620 Topics