Questions

3 answers

Different Header Without Section Breaks

Hello everyone, I have a document where each page has a header (see below) with number of revisions. Different pages can have different number of revisions so I am looking for a way to change 'Rev: 0' on each page without using section breaks. '0' can be…

asked

Anonymous

6 answers

Excel formula - trying to divide a factor of 0 in the formula / equation in a cell

Hi , i'm kind of new to excel, bumbling along trying to make some formulas work that include the value 0, when using a division in the formula SUM excel does not like the input 0 and will not divide and an error message comes @DIV/0!. now i've followed…

asked

Anonymous

6 answers

Excel on IPhone Crashing

When I open an excel file located on one drive on excel app on my iPhone and switch from one worksheet to another the app crashes.

asked

Anonymous

3 answers

O365 Word Home screen Recent list is showing wrong file names

Hi all I have O365 on W11 When I open Word there is a list of recent files. They have bene created form the same original file, but saved with slightly different file names However the list on the Home screen shows the file name as all the same The top…

asked

Anonymous

5 answers

Access left outer join error 4104

I have written a very simply query similar to many before but this does not work. It is based on 2 existing queries: Query 1 - a list of all items of certain types Query 2 - a list of when some of those items were checked each item has a unique ID, and…

asked

Anonymous

2 answers

How to export OneNote notebook from OneDrive Sharepoint account to a personal Microsoft 365 OneDrive account?

Hi, as a student about to graduate from my university, I have OneNote notebooks that are currently created and stored under my university's SharePoint account. As my SharePoint will no longer be in use once I am no longer a student, I hope to transfer…

asked

Anonymous

2 answers

Excel Formula using IF across tabs

Hello all, I do the invoicing at work and its so old school and one particular part of it is charging for late vehicles. I have to go through the Log to look for which were late and hand write out the Booking Ref, Customer Ref and customer name and how…

asked

Anonymous

6 answers

Cannot Delete Shape in PowerPoint.

I cannot delete or move a shape in PowerPoint. When I attempt to delete or Cut, nothing happens. When I try to move it, it snaps back to where it originally was. It is not locked or grouped.

asked

Anonymous

9 answers

What causes a document to prompt a user with the 'Pick up Where you Left Off' quick tip

I will skip my complaint about annoying a user with an unwanted and unnecessary 'quick tip' every time I open the application (the giant button is right there under the quick tip...I know where it is and what it does after thousands of quick tips telling…

asked

Anonymous

1 answer

Publisher Printing in Black and White

When trying to print from publisher, printer is stuck on black and white regardless of the settings, if you open printer properties then click out of there the printer reacts to setting in publisher Any ideas on how to fix this?, a reinstall doesn't…

asked

Anonymous

1 answer

Need to transfer Microsoft Office Professional 2021 for Windows: Lifetime License to another user

Problem: Need to transfer Microsoft Office Professional 2021 for Windows: Lifetime License to another user. Situation: While assisting a friend, i purchased a copy of Microsoft Office Professional 2021 for Windows: Lifetime License online to update his…

asked

Anonymous

2 answers

xlookup next steps

Hi all, I have an XLOOKUP formula which works, but i need it to continue returning matches and not just stop at the first result. I have done some googling and it seems possible but is way beyond me. Is anyone able to…

asked

Anonymous

1 answer

Data Sync Issues

Hello, I cannot sync or refresh data in one drive, failing the M query in PBI. (I am admin user in PBI) Errors are: We can not merge changes made by another user. Someone else is editing the file, we cant make changes. Data Source…

asked

Anonymous

7 answers

Cascading Combo boxes are showing the same data

Hello. I'm a computer repair tech and I've created a database to keep track of laptops that I've worked on, and what I did to fix them and what parts they need. I want combo boxes because each laptop model has different parts descriptions and part…

asked

Anonymous

10 answers

Protected Excel Workbook SharePoint issue

My company is trying to utilize SharePoint to support our quoting process. We use a password protected Excel workbook with various tabs - some with sensitive confidential information. The entire workbook as well as some specific worksheets are password…

asked

Anonymous

1 answer

Active X Issues PowerPoint

I need your assistance in reviewing the ActiveX designer feature in PowerPoint. For some odd reason, when the presentation is played it shows missing words in the checkboxes. This is not an input mistake on my part, because I've re-typed and copy / paste…

asked

Anonymous

2 answers

How to split a powerpoint presentation into 4 different sections. Each section plays automatically but will need to stop before the next section and add interaction.

My intention is to effectively have different presentations within one powerpoint and play them automatically; but at the end of each section, the user can interact by either repeat the section, or go to the next section. I haven't been able to find this…

asked

Anonymous

5 answers

Table Lookup Formula

I need help with a formula to complete cells C21-C25 and D21-D25 in the table below. The Cells in C4-J4 are the names of banks. These are the same names that appear in column B21-25. In Cells C21-C25 I want a count of the number of accounts that we…

asked

Anonymous

1 answer

[Macbook, Mac] Microsoft Office (Word, Excel, Powerpoint...) crashes (after start) with an error [solved]

Hi, For the last 2 days I was trying to find the solution for the issues with MS Office on MacBook. The issue was that Word, Excel and any other MS Office app was crashing with an error: EXC_BAD_ACCESS and KERN_INVALID_ADDRESS with crashed module name…

asked

Anonymous

3 answers

Access to new Excel features as an Insider

Hello, I saw a video about a few new Excel features (VSTACK, HSTACK, TEXTAFTER, TEXTBEFORE & TEXTSPLIT) that were supposed to be available to the Insider community. I joined yesterday and have made sure that my Office 365 account/apps are all updated…

asked

Anonymous

Filter

Content

1,801,500 questions

Different Header Without Section Breaks

Excel formula - trying to divide a factor of 0 in the formula / equation in a cell

Excel on IPhone Crashing

O365 Word Home screen Recent list is showing wrong file names

Access left outer join error 4104

How to export OneNote notebook from OneDrive Sharepoint account to a personal Microsoft 365 OneDrive account?

Excel Formula using IF across tabs

Cannot Delete Shape in PowerPoint.

What causes a document to prompt a user with the 'Pick up Where you Left Off' quick tip

Publisher Printing in Black and White

Need to transfer Microsoft Office Professional 2021 for Windows: Lifetime License to another user

xlookup next steps

Data Sync Issues

Cascading Combo boxes are showing the same data

Protected Excel Workbook SharePoint issue

Active X Issues PowerPoint

How to split a powerpoint presentation into 4 different sections. Each section plays automatically but will need to stop before the next section and add interaction.

Table Lookup Formula

[Macbook, Mac] Microsoft Office (Word, Excel, Powerpoint...) crashes (after start) with an error [solved]

Access to new Excel features as an Insider