why /me/drive/SharedWithMe Returns "value": []
I'm getting it: R R I'm getting it "error": { "code": "accessDenied", "message": "Access denied", "innerError": { "date":…
Multi-conditional search returns non-duplicate values
Returns the non-repeating value of column A according to the date and name
Power Query Contains in collum
Hello I wanted to make a function, in which, if the value of column 1 is inside column 2, show "yes" if not, show "No"
![](https://techprofile.blob.core.windows.net/images/aYf80cOltkiJ-ccSQml4Mw.png?8D8292)
How to fix excel student account credential?
Hi Unfortunately, I just disabled my student credential for excel. From managing device options I disabled it. Please help me with this. How can I fix this issue?
![](https://techprofile.blob.core.windows.net/images/xHj-uAAAAwAAAAAAAAAAAA.png?8DAFF7)
Is there any way to load wininet.dll using macros, scripts, or PowerShell??
Hi guys ! I use a couple of macros that handle files in SharePoint thru commands like "Dir" , "Save" , "open" etc. Many of these commands (Dir for instance) do not work if wininet.dll is not "loaded". In the…
The current .NET security policy prohibits C:\Users\...\File.xlsx from loading custom macros.
I am working on a project in Visual Studio Community 2022. The project is an Excel VSTO Workbook using Visual Basic (Target framework is .NET Framework 4.8). Up until yesterday everything was working fine, I could run and debug my project whenever I…
![](https://techprofile.blob.core.windows.net/images/PIRaMWjmIEixs59vW9Bi9g.png?8DAC2C)
1. i have an excel file which is called 20221226_Cash Flow_KA. 2. in this Excel file a query of CSV files is made by power query. These files are located in the folder current accounts. Accordingly, the worksheet that is output by the query is called Curr
i have an excel file which is called 20221226_Cash Flow_KA. in this Excel file a query of CSV files is made by power query. These files are located in the folder current accounts. Accordingly, the worksheet that is output by the query is called…
![](https://techprofile.blob.core.windows.net/images/aYf80cOltkiJ-ccSQml4Mw.png?8D8292)
Importing excel data to MS SQL using EPPlus
I am writing a C# code in .Net 6 to read data from excel and save them into the database. when reading the column with date/ date time value I realized that if the cell contains a time portion, Epplus will return the cell value as 9/1/2000 8:00:00 AM,…
![](https://techprofile.blob.core.windows.net/images/_KR_hQAAAwAAAAAAAAAAAA.png?8D8440)
Thousand Separator support for different region in Excel addin
Hi Team, - We are offering a Excel addin where user can upload local excel and save it to onedrive, The addin is available on office store. - In this Addin we are providing one feature where user can upload numbers in any region format(thousand…
Trying to Rescale images remotely in word from excel macro
For my company one of the processes is copying graphs from an Excel spreadsheet and pasting them into a word document. However, these graphs are pasted slightly too big and need to be descaled to 80% their original size. I'm trying to write a macro in…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
Accessing Cheaper/Free Student Certifications
I work with students with disabilities and all are in technology classes working with Microsoft Applications. We are wanting to look at having some of them try for their certifications but cannot pay the $100 for each test knowing many may not be able to…
![](https://techprofile.blob.core.windows.net/images/aYf80cOltkiJ-ccSQml4Mw.png?8D8292)
C# Office.Interop.Excel How do I loop through the AutoFilter'd returned rows?
I have created the following AutoFilter: excelRange = excelWorksheet.get_Range("G1"); excelRange.AutoFilter(Field: 7, Criteria1: "Part Number"); excelRange.AutoFilter(Field: 7, Criteria1: ">A*", Operator:…
Question about Dynamics Business Central & Excel
Hi- I am a beginner using Microsoft products and have been at my job 5 months. My boss gave me a new task which is to... using a an Excel master file we have which list every inventory item we have and the cost and pricing etc. All anyone know to do is…
Getting ORA-12154 - TNS: could not resolve service name error in Excel 365
My client recently upgraded his Microsoft Office suite from 2016 to 365 on his workstation. I am working with a him on getting his spreadsheet that was created in Excel 2016 (32 bit) connecting to a Oracle database. He has no problem opening the…
![](https://techprofile.blob.core.windows.net/images/aYf80cOltkiJ-ccSQml4Mw.png?8D8292)
Can I save pivot table in compatibility mode?
I'm trying to save a pivot table and I see the file is in compatibility mode will that prevent me from saving the pivot table?
![](https://techprofile.blob.core.windows.net/images/f9yyiYKH2kqEaeewksEZVg.png?8D9F6A)
Where are located default preferences for Excel on MacOS?
Hi, I want to change some preferences used by default by Excel on MacOS, to be used for any new file. Especially, I would like to set the calculation mode to automatic, but changing this in the Excel preferences windows (Excel Menu => Preferences)…
![](https://techprofile.blob.core.windows.net/images/f9yyiYKH2kqEaeewksEZVg.png?8D9F6A)
Word document - worksheet object not opening in word it is not opening a new file in excel
Beginning last week, my word document excel object stopped opening in the microsoft word program. Instead, it opens up the excel workbook. The problem with this, I have lost the ability to resize to the inputted rows in word. This is a shared…
![](https://techprofile.blob.core.windows.net/images/f9yyiYKH2kqEaeewksEZVg.png?8D9F6A)
Prompt to enable Macro's isn't consistent Office 2019 - Excel
Hello, I was wondering if anyone would be able to provide some insight on why it seems the prompt to enable macro's on Excel behaves very inconsistently. Our CRM system gives files the 'Mark of the Web' so following the recent changes…
![](https://techprofile.blob.core.windows.net/images/f9yyiYKH2kqEaeewksEZVg.png?8D9F6A)
In a team channel why does an excel spreadsheet duplicate and add on my device name at the end of the file?
I was working on an excel spreadsheet and some how made a copy and my laptop name was added onto the end of the file name.
![](https://techprofile.blob.core.windows.net/images/f9yyiYKH2kqEaeewksEZVg.png?8D9F6A)