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.…
Find correct SUM value of inventory before a date
PLEASE BE INFORMED THAT I WANT TO HAVE THE SOLUTION IN EXCEL NOT POWER BI Hi all, I have a dataset and want to perform some calculations with a measure. To this end, I have changed the AdventureWorks dataset (publicly available) to make my problem more…
Calling Snowflake Stored Procedure from inside Microsoft Excel gets data for preview but doesn't load rows into spreadsheet
I have a Snowflake Stored Procedure that performs a simple Selection and Update on <100 rows. It then returns the selected rows as a new table. I have an ODBC connection to Snowflake that I am then using to call this Stored Procedure from inside a new…
number format in excel sheet
Hi Expert how to change datatype in pivot table in excel sheets . from text to numbers currently value is in text as it is in column section i,e. id value 1 23
Compatible mode
My university has an agreement with Microsoft about word, excell and powerpoint. I have used to have the program with this way. But today it has an alert and says that your account doesn't allow to edit on a Mac. How to get fixed the problem?
How to use formulas in excel when exporting data using forms?
The formula I am using is =IF(COUNTBLANK(B12)=0, VLOOKUP(B12,lookupTab,2,0), "") It all works perfectly UNTIL I submit a new answer on the forms then the cells shift when new information is added and therefore it doesn't correctly give the…
Unable to open embedded word files in excel - 'cannot start the source application for this file' error message
Updated to windows 11 start of the year (unable to roll back) - all excel documents that have 1 or more word documents in them cannot be opened- 'cannot start the source application for this file'. =EMBED("Document","" is in the…
How to fix the Word/Excel error message....
This issue is only on one pc but they can open all pdf's documents with the cloud folders - they can see all contents within the folders. All updates have been completed for 365 apps. This machine can open the document if sent to the pc via Teams/…
my office shows error it came preinstalled with my laptop but all of a sudden it showing need to signup again do i need to buy new office subscription?
recently i am seeing an error whenever i am opening excel or any office apps, microsoft office came preinstalled on my system by default but now its showing some errors what should i do now
new computer, same configuration but excel dosen't work with RTD data from trading software
Hello, I use an excel spreadsheet linked to the CME E-quotes platform via RTD to receive live feeds of prices; i bought new computer but now i can't figure how to make it work. Old computer has Windows 10 and Office 2013; new computer has the same; the…
Automatically transfer information from one spreadsheet to another based on id number
I have 2 different sheets with cattle data. Weights, birthdate, names, etc.. One sheet contains information and the other sheet is has some information, but needs to have weights, birthdate, etc transferred from the completed spreadsheet to the…
Excel to API without going through Power Query
Hello! We recently connected Power BI to our API and Power BI read the data right into a table (just about automatically). We want to do the same thing with an Excel connection to our API. However, every tutorial and video I've seen shows that you must…
Change active page of Vision object in Excel
I have an Excel document in which I inserted Visio object. It has a few pages, each page has a specific model and according to some checkboxes in excel I want to choose a specific page, so when I print the excel, it will have specific model from visio.…
PowerBI怎么用折线图反映今年和去年的同期数据
如何对比2022年1月和2023年一月的数据? X轴放什么? 两年的数据是分别建了日期表计算的,,求大神指导,,小白自学实在是搞不明白了 想要实现的是像图二PPT版本这样的两根折线图
If I sign in to Microsoft on another computer can I see my excel files.
I signed into another computer with my microsoft account and could see my excel file history. Were the files also there
How to download rest api response content into excel using windows forms application c#
I'm trying to download REST API response content as (original format) excel (.xlsx) And I have used this method to return the response content public static string DownloadFileName() { try { var client = new…
M365 VBA Compatibility Issues with TN3270 Emulator
I am experiencing M365 VBA Compatibility Issues with TN3270 Emulator. I cannot find any documentation, so your experience on the subject is much appreciated. I have an enterprise client running legacy TN3270 Emulator. I developed an Employee Survey in…
Can you create a sql query to look up the data entered into a cell?
looking to create a formula that will look up every entry in a list that has the specific value which would be entered into cell A1
Best courses to become certified in Excel and PowerPoint
I would like to become certified in excel, What is the best option in doin this? Thank you
Using Shell Namespace method "GetDetailsOf" causes excel to crash
I'm using a vba script to summarize a list of data files in certain folders so I can manage those files (mark important, not important, whether I've used them in presentations, etc.). The files are created by a program called Vector CANape and are MDF…