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…
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…
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,…
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…
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…
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…
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?
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)…
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…
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…
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.
undo change in two worksheets
When I have two worksheets open and I copy information from one to another, when I undo a change in one, I undo the other one as well. How to take it off?
How do I access the contents of a cell in another worksheet
As I update Income projections in one worksheet (e.g."income"), I want those updates to be reflected (updated) in a second worksheet (e.g."Budget").
How to update cells in a row when a particular cell in the same row is changed
I have a 2 page excel file. Page 1: "List" page has 6 columns and infinite rows Column names: A: Date B: Symbol, Text C: Source, =TradeSource D SignalApp, =INDIRECT($C2,TRUE) E: Pattern, =INDIRECT($D2,TRUE) F: Cull Date "Source, App,…
Excel Power Query equivalent for an excel formula
Hi there, I am super new to Power Query in Excel and hoping to get some help. I am not sure if what I am asking is possible or not but thought I'd reach out and ask. I have a column in an excel power query with hours represented in a decimal format. In…
Microsoft office Excel 2021 with FSlogix 2.9.8228.50276
We implemented a VDI solution with Windows 10 Ent, Fslogix 2.9.8228.50276, with the Profile Container active and storing the VHDX to an SSD storage. However, we have noticed a strange behavior with the office tools, in particular with excel 2021.…