Excel Online

634 Topics

Need help with Excel
I made an Excel worksheet database, but the dumb thing is way to long and deep - how do I control unused rows and columns since Excel fabricates thousands of these? I haven't used Excel much so I'm just learning.
Solved
Deleted
Jul 07, 2025 Place Excel
66KViews
1like
10Comments
Cannot run the macro 'SOLVER.XLAM!GetSolverLabel'.
Hi, I need to use the solver add-in for my studies. However, Every time I try to use it I get an error: "Cannot run the macro 'SOLVER.XLAM!GetSolverLabel'. The macro may not be avaliable in this workbook or all macros may be disabled." Even if I uninstalled Office products on my PC, the error was not solved. I will be glad if you solve this problem. Thanks,
Solved
muhammet atasever
Nov 18, 2024 Place Excel
87KViews
3likes
21Comments
To allocate stock from closing stock by formula
HI Guys, i've tried lots of times to get a solution for my problem. but still not sorted that. here attached my chart with two tables. in first table i have mentioned order number delivery date of that order number / required items order number wise and required qtys. in my second table i have mentioned items wise closing stock details. most of the items common for every order number. i need to allocate stock to first table from second table closing stock. for this i need to prioritize delivery date. as a example if i have 8000 pcs of closing stock in one item in second table and 1st table 1 have 5000 wise two deliveries. i need to allocate 1st 5000 for first delivery and balance 3000 for second delivery) any one can help for me?
Solved
Ravindu94
Oct 15, 2024 Place Excel
12KViews
0likes
10Comments
Sharing in Excel Online in OneDrive - Pivot table slicers don't appear in Android web browser
I'm having a strange problem with Excel online, and here is my example sheet for you to try: https://1drv.ms/x/s!AhTZr-GdLCi2aRKYt60Nt5j7cT0 In a browser on a desktop computer (in my case Chrome) it looks like this, and the slicers work as they are meant to: However, when I open the same link on my Android phone (Samsung Galaxy S5, Chrome) the slicers don't appear, and there is no placeholder like you sometimes get when slicers don't render: Why are the slicers not displaying on mobile, and what can I do to fix the problem? By contrast, if you choose to open the file in 'Excel' on the mobile, which is the mobile Excel Android app as opposed to Excel Online... ...you get the following warning becase slicers aren't supported: It's all very confusing. What I don't understand is why slicers won't appear when viewed in browser on my mobile phone. On my Android tablet the slicers appear to work fine, using the same link! Thanks
johnrtullis
Sep 15, 2024 Place Excel
11KViews
2likes
6Comments
Colours of conditional formatiing are changing when copying from one workbook to another
Hi I am using Excel 2016 and I have a spreadsheet with colour coding on it (this spreadsheet is saved in OneDrive). When I copy this to another Excel workbook the colours of the conditional formatting are completely different. Why would this be?
Solved
Craig Dixon
Sep 12, 2024 Place Excel
734Views
0likes
2Comments
Conditional Formatting - formula for adjacent cells
Hello, Sorry for posting again but I got no response on my original post, so here I am trying again. If anyone could help me that would be great! I need to set up conditional formatting for a column where the cell turns red or green based on the information in the cell to their left. I have the following information in an Excel sheet: November Expected Actual 0 1 20 19 60 40 20 20 Now I want to set conditional formatting for column B "Actual". If: B3 >= A3 then B3 is green; B3 < A3 then B3 is red. And so on for the following rows: B4 >= A4, B4 is green / B4 < A4, B4 is red, etc. etc. I'm not sure how to set this up without having to set conditional formatting for every single cell. And since I have many more of these collumns and rows I really do not want to do that. Is there a formula that I could use? Thanks in advance for your help!
Solved
Noortje Vollenberg
Aug 14, 2024 Place Excel
59KViews
1like
4Comments
VLookup to an image in excel
Hello, I want to create a sheet in excel that houses 2 columns of data: 1. 10 digit item code 2. Photo of the 10 digit item code In a separate sheet, I want to be able to reference the 10 digit item code in column 1 and have it populate with the image in column 2. I figured the best way to go about this would be through a VLookup, but can't seem to figure out how to link text with an image and reference it through a VLookup. Any tips/tricks appreciated. Thanks!
skendzi
Jul 29, 2024 Place Excel
35KViews
0likes
2Comments
Combine data from 2 columns into 1 column
I want to do this, but with 2 columns of data. We have a sheet with area codes in one field and phone numbers in another. I need the 2 pieces of data in one field for a list of 500 phone numbers. Do I have to do them one at a time???? Combine data with the Ampersand symbol (&) Select the cell where you want to put the combined data. Type = and select the first cell you want to combine. Type & and use quotation marks with a space enclosed. Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.
radfordsix
Jun 11, 2024 Place Excel
2MViews
3likes
13Comments
Microsoft Excel keeping all cells uppercase
I have a spreadsheet that several people use and would like to keep the text in a particular column always set to upper case. Regardless of case the user enters the data in this column it is saved in upper case. Is this possible? Thank you for your input. Greg
Greg Daughenbaugh
Mar 18, 2024 Place Excel
129KViews
0likes
12Comments
Excel Formula works in desktop, but not web.
Hello - I have a formula that automatically pulls the Excel tab name into a call. It works great in the desktop program, but I get a Value error when using the formula in Excel on the web. Here is the formula: =MID(CELL("Filename",I7),SEARCH("]",CELL("Filename",I7),1)+1,32) Thoughts?
Solved
Dave Galy
Feb 26, 2024 Place Excel
6KViews
0likes
2Comments