Does Virus & Threat Protection Scan of Excel 365 Enterprise Web Workbooks increase Crash and/or Freezing Risk? How to improve?
To reduce risk of crashing and freezing of trusted Excel Web Workbooks, are there settings to exclude Virus & Threat Protection Scan ? Excluding folder has drawbacks I need IT approval folder can include non-trusted Workbooks IMHO, without trial…
![](https://techprofile.blob.core.windows.net/images/KaKrszN1SEij74ysS0dYnw.png?8DB3C9)
how to resolve a aceoledb.dll!GetModuleMsoSynchronizer error
I have a IIS asp program that reads a uploaded Excel file and puts the contents into database. There is a sample source like below: Set connXLS = Server.CreateObject("ADODB.Connection") connStrXLS =…
Run-time Error '-2147467259 (80004005): The export failed because this feature is not installed.
I have written an Excel macro that Opens a word document populates several bookmarked fields exports the word document to pdf file; Problem is that when the command Doc.ExportAsFixedFormat PDFFilePath & VBA.Replace(WordFileName,…
POWER QUERY how get data from website that need to click javascript button to see data
Hi , I can get data from normal html link but , on same page there is a javascript button and there are different data after you click the link, Simply i can get data from the first link but cant get data after i click javascipt button link. I want to…
How would you check an Excel columns in order to compare with a data in the database table?
Hello folks, I am working on a Blazor Server application. I would like to upload an excel file, consisting of a couple of columns. (ReferenceId-guid, Order Date-datetime, Product Code-string, and Product Description-string) This excel file roughly has…
How to split two stacked blocks of data using repeated identifiers in Power Query Editor.
I am trying to aggregate multiple Excel files using power query editor but the files have two stacked tables with different data for the same samples (first picture). In power query editor I'm having trouble figuring out how to tell it to create new…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
Merge two tables without refreshing one in Excel Power Query
I am loading two tables into Power Query in Excel. One is a large SQL based table, the other a small worksheet based table. I currently append the worksheet based table to the SQL table in order to manually add a few lines to the dataset. However, now…
![](https://techprofile.blob.core.windows.net/images/aYf80cOltkiJ-ccSQml4Mw.png?8D8292)
Excel files from Microsoft office Mac 2011 to 2021
I am in the process of purchasing a new iMac desktop, I have existing excel files from Microsoft office home & student 2011, I will purchase Microsoft office home & student 2021. Do I need to import files into Microsoft Office home & student…