Forum Widgets
Latest Discussions
Office Scripts
i have a business microsoft office account and am signed in with it. when i try running a script in excel i keep getting the error saying it requires a work or school account. my microsoft account says the following: your work or school account belongs to your home organisation. what do i need to do to get scripts working.
Allow removal of "Copilot Suggestions" from right-click menu
I have been using Excel for decades and CONSTANTLY use the right-click menu for quick access to basic functions (e.g., "Insert"). Ever since "Copilot Suggestions" was added to the drop-down list, it always throws me off due to its placement. I have Microsoft 365 on Windows 11 Pro. I have searched for ways to remove this from appearing there and the result said "go to File > Options > Copilot and uncheck the 'Enable Copilot' box". However, when I attempt to do that, there is NO "Copilot" option available! PLEASE allow removal of "Copilot Suggestions" from the right-click menu OR at least the option to move it to the bottom (so it isn't in the way of things used ALL the time). I realize that Copilot is a great resource for many users, but I am confident in my Excel skills and in my ability to research/learn new skills the "old school" way, so I have little use for this feature now and would prefer to hide it.
How can I overcome the HYPERLINK Functions 255 character limit?
Hi! I am trying to workout how to overcome the 255 character limit for the hyperlink function in excel. Currently I have formulated a HYPERLINK link which pre-populates information for a 3rd party form (JotForm) with values from my spreadsheet. It displays #VALUE! in the cell. Does anybody have any suggestions or solutions for overcoming this issue? Thanks!
Pull data from other tab
Hopefully I can explain correctly. I have a calendar tab and on this tab, I have a box that is to give me my PTO available hours. The PTO available hours are located on a separate tab. My goal is to pull my available PTO hours over to the calendar tab BUT I'm trying to figure out if I can pull it based on today's date. Currently on my PTO tab I have the whole years worth of PTO so the calendar tab is pulling that last PTO available (December's). Any help would be greatly appreciated. Thanks
#DIVISION/0!
Hi. I have a problem (this is in Swedish) where I get #DIVISION/0! in a field in excel. The formula in the field is =AVRUNDA(MEDEL(G4:G22);2) Translated I think it is =ROUND(AVERAGE(G4:G22);2) I have tried to do as you described with =IFERROR(AVRUNDA(MEDEL(G4:G22);2),"") But I get an error message.
Creating weekly calendar template that has overlapping positions
Hi, I have a software for individuals to sign up for shifts, but it is visually hard to see where there are open areas that need to be filled. I need help creating a calendar from this software download that I can update each week. It would have to be much like an hourly scheduler view to easily see when someone is coming on and off shift. But also laid out from Sun-Saturday. There is 3-4 "slots" for each day. It would be great if they could be color coded as well. Slot 1 needs to be anyone that is "AEMT" in the position column, Slot 2 can be anyone listed as "EMT" or "EMR" (caveat to this would be that slot 2 could also be AEMT if there is already an AEMT in slot 1 for the same time slot. Slot 3 is for driver or ride along (or the other 3 positions if there is one listed in the other slots), and possibly 4th slot would just be overflow in case there were 4 people signed up which does not happen very often. Is there anyone who can help me with designing this? Below is what the software generates when converting to excelSuddenly don't have access to charts (grayed out)
I have owned MS Office (not 365) for a few years and I had been charting my financial data that I enter into an Excel spreadsheet each week. Now, suddenly, when I try to chart my data, the recommended chart icon is grayed out as is all the specific choices of charts. Pivot Tables icon seems to work. What happened and how do I fix it?
Insert a row
Hello, I want to insert a row in Excel to shift the existing data downward, but an error message prevents me from doing so, stating that non-empty cells would be pushed off the edge of the worksheet. Could you please tell me how to insert this row without deleting my existing data? thank you !Select from multiple conditional format rules, based on value of another cell.
I have a spreadsheet tracking due dates for deliverables, depending on what department a deliverable is for, the acceptable time taken from order to delivery varies. On Column H, I have a formula that calculates how many days OVER the acceptable time a delivery is, I want a conditional format that colours that cell on a gradient from 1 to 150, going yellow to deep red. So a quick visual inspect will show which ones are going to be a major problem. The difficulty being the gradienjt scale will have to change depending on the department that deliverable is for. So in Column C I have the department name, this gives Column D data to look up in a config tab, that lets it check how many days is considered late using a basic Vlookup ona small table that is just two columns Dept Name, and acceptable days late number. =IF(C2="","",VLOOKUP(C2,Configuration!D$4:E$6,2,FALSE)) Then Column H looks at the order date(Col F) and delivery due date (Col G), and checks if the time between is over or under the acceptable range with a simple comparison and show how many days (If any) late the delivery will be. =IF(G2-F2>D2,(G2-F2)-D2,"") I want Column H to be conditionally formatted with the mentioned gradient, however the conditions for that gradient will change depending on whats in the Department Column C, some departments consider 14 days over to be acceptable (coloured yellow), some departments see 8 days as a critical issue (Coloured deep red). So my question is how I apply a different Conditional Formatting Rule to the cell in Col H, depending on the value of Col C. If thats even possible. I know I can do it with a macro, but I want to try keep this worksheet formula's only if possible as the person using it does not use VBA and wouldn't know how to troubleshoot if something went wrong, whereas I could explain a formula to them.
