​Ive tried multiple accounts and multiple browsers. not sure what to do here.Microsoft runs on trust. We engage in a rigorous set of evaluation and certification processes; as a result your request was blocked. If you require further information please reach out to Microsoft support with reference number: 715-123225 and transaction ID: 53abbb9d-aff4-418f-a1a1-a52c8b105fe2.Correlation ID: 99060708-03ad-44df-9ed1-7df1e015f6b0  Read More

​

Within one workbook, I have a products list with unique IDs. Each month new inventory comes in and at the end of the month inventory is counted. There is a tab for each month.
COL A- product unique ID

COL B- product name 

COL C- starting count (same as end of month count, COL F from previous month) 

COL D- incoming count

COL E- formula of amount distributed 

COL F- end of month count 

For simplicity let’s say in January there are 3 products. Rows: 

ROW 1- headers

ROW 2- product 1

ROW 3 -Product 2

ROW 4- Product 3

ROW 5- TOTALS

PROBLEM: every month we get 1 or 2 new products (adding a row or 2). I am trying to figure out how to maintain a master products list of the product and unique IDs that will update across all months. This would need to push the total row down (I’m not opposed to moving total to the top) AND keep the formulas in COL C and E (COL D and F are manual input). 

is this possible? 

​Within one workbook, I have a products list with unique IDs. Each month new inventory comes in and at the end of the month inventory is counted. There is a tab for each month.COL A- product unique IDCOL B- product name COL C- starting count (same as end of month count, COL F from previous month) COL D- incoming countCOL E- formula of amount distributed COL F- end of month count For simplicity let’s say in January there are 3 products. Rows: ROW 1- headersROW 2- product 1ROW 3 -Product 2ROW 4- Product 3ROW 5- TOTALS PROBLEM: every month we get 1 or 2 new products (adding a row or 2). I am trying to figure out how to maintain a master products list of the product and unique IDs that will update across all months. This would need to push the total row down (I’m not opposed to moving total to the top) AND keep the formulas in COL C and E (COL D and F are manual input). is this possible?   Read More

​

I have created an Outlook Group Email, but when the recipients receive the email, they are not able to “Reply All.” The reply only comes back to me and not the entire group. How do I change this so they can respond to everyone in the group?

​I have created an Outlook Group Email, but when the recipients receive the email, they are not able to “Reply All.” The reply only comes back to me and not the entire group. How do I change this so they can respond to everyone in the group?   Read More

​

While I was playing a game on steam, my second monitor suddenly went black and hasn’t worked since.

Specifically the display is detected by windows and my mouse can go from my main monitor to the second but as soon as my mouse goes to monitor 2 it disappears. It is as if there is a black screen covering everything. Applications can be open and function but it is all black.

I tried restarting, unplugging monitor, wiping and reinstalling graphics drivers but nothing has worked

Any help would be appreciated

Ryzen 5 5600X

16gb Corsair Vengeance 3600mhz

MSI GeForce RTX 3060

Windows 10 64-bit

​While I was playing a game on steam, my second monitor suddenly went black and hasn’t worked since.Specifically the display is detected by windows and my mouse can go from my main monitor to the second but as soon as my mouse goes to monitor 2 it disappears. It is as if there is a black screen covering everything. Applications can be open and function but it is all black. I tried restarting, unplugging monitor, wiping and reinstalling graphics drivers but nothing has worked Any help would be appreciated Ryzen 5 5600X16gb Corsair Vengeance 3600mhzMSI GeForce RTX 3060Windows 10 64-bit   Read More

​

Hallo Zusammen

Bin neu und anfänger

Habe eine Umfrage Erstellt und es mit outlook verknụ̈pft.das geht einwandfrei

Das Problem ist wenn ich vom outlook es im planner Mache übernimmt es mir den link nicht.nur der text wo auch der link wäre vom Forms wo ich im outlook bekomme.

Was muss ich machen was mir der link anzeigt im planner fụ̈r die fotos?

​Hallo ZusammenBin neu und anfängerHabe eine Umfrage Erstellt und es mit outlook verknụ̈pft.das geht einwandfreiDas Problem ist wenn ich vom outlook es im planner Mache übernimmt es mir den link nicht.nur der text wo auch der link wäre vom Forms wo ich im outlook bekomme.Was muss ich machen was mir der link anzeigt im planner fụ̈r die fotos?    Read More

​

I have a simple formula that I only want to find replace one mathematical sign.  I have many cells with the original formula and multiple s.  I tried using the * in place of the cell name and it did okay finding the formula but it would not replace the formula using the *.  Is there a way to do this or do I have to do the copy and paste the new formula in several columns, several worksheet 

from

A1+B1-C1 to A1-B1-C1

A2+B2-C2 TO A2-B2-C2 

and so on

​I have a simple formula that I only want to find replace one mathematical sign.  I have many cells with the original formula and multiple s.  I tried using the * in place of the cell name and it did okay finding the formula but it would not replace the formula using the *.  Is there a way to do this or do I have to do the copy and paste the new formula in several columns, several worksheet fromA1+B1-C1 to A1-B1-C1A2+B2-C2 TO A2-B2-C2 and so on  Read More

​

I see lots of posts around partner verification issues, I am not part of the verification team or support, this is information received from support on what is acceptable. Please be sure to read all the details around registering your company name and the expiration date of your domain paperwork. That most often is the issue… 

———————————

Acceptable document for Business verification types include:

• Formation documents, such as articles of incorporation, partnership deed
• Franchise or agency appointment letters.
• Government issued letters, license, registration, or certificate.
• Lease or tenancy documents.
• Letter or statement from a financial institution or a utility company
• Record on a Government registry website (site/link must be displayed)
• Stock exchange filings or tax filing records.
• Certificate of incorporation or registration
• Extract from commercial register.
• Business license
• Tax certificate.
• DUNS certification

For domain verification please provide the domain registration or domain invoice from registration or renewal that lists the entity/contact name and domain as it is stated on your account exactly. **For instance, if your domain paperwork states your company is Fakecompany.com you register Fakecompany.com in partner center under company name along with the company address listed on the domain paperwork. If you do not, you will be rejected**

If applicable, documents submitted should be issued within the previous 12 months or where the expiration date is a future date that is at least 2 months away.

PLEASE DOUBLE CHECK YOUR DETAILS, it may help you get through the process! 

​ 
I see lots of posts around partner verification issues, I am not part of the verification team or support, this is information received from support on what is acceptable. Please be sure to read all the details around registering your company name and the expiration date of your domain paperwork. That most often is the issue… 
 
———————————
 
 
Acceptable document for Business verification types include:
• Formation documents, such as articles of incorporation, partnership deed• Franchise or agency appointment letters.• Government issued letters, license, registration, or certificate.• Lease or tenancy documents.• Letter or statement from a financial institution or a utility company• Record on a Government registry website (site/link must be displayed)• Stock exchange filings or tax filing records.• Certificate of incorporation or registration• Extract from commercial register.• Business license• Tax certificate.• DUNS certificationFor domain verification please provide the domain registration or domain invoice from registration or renewal that lists the entity/contact name and domain as it is stated on your account exactly. **For instance, if your domain paperwork states your company is Fakecompany.com you register Fakecompany.com in partner center under company name along with the company address listed on the domain paperwork. If you do not, you will be rejected**If applicable, documents submitted should be issued within the previous 12 months or where the expiration date is a future date that is at least 2 months away.
PLEASE DOUBLE CHECK YOUR DETAILS, it may help you get through the process!   Read More

​

I have never used macros in Excel, only formulas, but if someone who knows about macros could help that would be great. I’m trying to use the “record” action, but don’t know exactly how to do that. I want a button to perform the following functions: test the positive and negative numbers in a set of cells (I2:K8) by inserting each one into cell A1 until cell G3 equals 0, then list the number in A1 that results in 0 in cell B6 as “(x-number)” Then the numbers in cells B3:G3 to be put into corresponding cells B1:G1, NOT counting the repeating zeros at the end, but DO count zeros in between numbers (eg, count the 0 in 12034, but not in 12340) 

Then all the above needs to be repeated until there are no more numbers, and after each round the resulting “(x-number)” needs to be moved a cell over (eg, the first round results in (x-number) in cell B6, the second round results in (x-number) in cell B7, and so on), until no more numbers remain in cells C1:G1.

ALSO… if none of the numbers in cells I2:K8 result in 0, the process above needs to stop, and say something like (unreal number) in the cell after the last (x-number) in row 6, and leave the remaining numbers alone. 

If you know anything about the synthetic division of polynomials it might help, as that’s what I’m trying to accomplish. If you have any questions or if I didn’t explain something well enough please let me know.

​I have never used macros in Excel, only formulas, but if someone who knows about macros could help that would be great. I’m trying to use the “record” action, but don’t know exactly how to do that. I want a button to perform the following functions: test the positive and negative numbers in a set of cells (I2:K8) by inserting each one into cell A1 until cell G3 equals 0, then list the number in A1 that results in 0 in cell B6 as “(x-number)” Then the numbers in cells B3:G3 to be put into corresponding cells B1:G1, NOT counting the repeating zeros at the end, but DO count zeros in between numbers (eg, count the 0 in 12034, but not in 12340) Then all the above needs to be repeated until there are no more numbers, and after each round the resulting “(x-number)” needs to be moved a cell over (eg, the first round results in (x-number) in cell B6, the second round results in (x-number) in cell B7, and so on), until no more numbers remain in cells C1:G1.ALSO… if none of the numbers in cells I2:K8 result in 0, the process above needs to stop, and say something like (unreal number) in the cell after the last (x-number) in row 6, and leave the remaining numbers alone. If you know anything about the synthetic division of polynomials it might help, as that’s what I’m trying to accomplish. If you have any questions or if I didn’t explain something well enough please let me know.   Read More

​

Hey Team,

This is seriously frustrating.

In previous versions of Word, it was possible to set a custom keyboard shortcut to bring up the “Paste Special” context menu.  This is ubiquitous because you don’t always want to use a specific paste special command (i.e. sometimes it’s paste as text, or sometimes I want to paste as Picture (Enhanced Metafile).  

In the new Excel and Visio, “paste Special” remains a command (which I have assigned to cntrl + alt + v) but the option to remove that has been removed from Word, as a side note I see that there are now several different “paste options” which can be used, but not “PasteEnhancedMetafile” (which is an option in the paste special popup.

Anyway, please add this feature back in. It’s really something that keeps Office in line with the rest of the MS365 apps.

Thanks!

​Hey Team, This is seriously frustrating.In previous versions of Word, it was possible to set a custom keyboard shortcut to bring up the “Paste Special” context menu.  This is ubiquitous because you don’t always want to use a specific paste special command (i.e. sometimes it’s paste as text, or sometimes I want to paste as Picture (Enhanced Metafile).  In the new Excel and Visio, “paste Special” remains a command (which I have assigned to cntrl + alt + v) but the option to remove that has been removed from Word, as a side note I see that there are now several different “paste options” which can be used, but not “PasteEnhancedMetafile” (which is an option in the paste special popup. Anyway, please add this feature back in. It’s really something that keeps Office in line with the rest of the MS365 apps. Thanks!   Read More

​

Hello.  I have an Excel workbook that has 60 different worksheets. Each worksheet has it’s own name (ie. 15-1157, 23-BR10, 24-VH02, etc).  I wanted to create a dropdown list to navigate to each sheet.  I’ve created a list and have made the dropdown from the list.  I tried to use the following formula in a cell next to the dropdown list:  =HYPERLINK(CONCAT(“#”,D1,”!A3″),”GO”).  D1 is the location of the dropdown list result.  I get a “reference isn’t valid” error.  Is there something missing from the formula?

Some info about the worksheets:

The dropdown list and Cell D1 (location of the list result) are both formatted as “General”

Calculations are set to Automatic

Unfortunately I cannot use visual basic or any macros so using a formula is my only option. 

​Hello.  I have an Excel workbook that has 60 different worksheets. Each worksheet has it’s own name (ie. 15-1157, 23-BR10, 24-VH02, etc).  I wanted to create a dropdown list to navigate to each sheet.  I’ve created a list and have made the dropdown from the list.  I tried to use the following formula in a cell next to the dropdown list:  =HYPERLINK(CONCAT(“#”,D1,”!A3″),”GO”).  D1 is the location of the dropdown list result.  I get a “reference isn’t valid” error.  Is there something missing from the formula? Some info about the worksheets:The dropdown list and Cell D1 (location of the list result) are both formatted as “General”Calculations are set to Automatic Unfortunately I cannot use visual basic or any macros so using a formula is my only option.     Read More

​