Saving the newly created files.
Hi All, I am using Microsoft 365 Apps for Enterprise. When I open any new Excel or Word document or any office application file AutoSave is disabled. Is this the default behavior? Can the AutoSave setting be changed for new Office 365 files? i am seeing…
Is there a way to search a date column for a date range and then if the date falls within a certain range, I would like to include any amount ordered within that date range in a sum. If the dates are outside that range, do not include the number ordered
Column A has different dates upon which product was ordered Column b has the number of product that were ordered on that date I want to sum up all the orders from, for example, October only. What is a formula to use to search column A for only dates…
Get live numbers from web into my excel sheet
I need to get live numbers from a web page (example, googlfinace) into my excel sheet, so I can keep my excel sheet updated at all time, fore purpose of quick action point.
how to fix this error
How can I solve this problem? Что-то пошло не так К сожалению, в текущий момент вход в систему недоступен, но мы стараемся устранить проблему. Повторите попытку позже. Если проблема сохраняется, обратитесь в службу поддержки и укажите следующие…
Upload Failed:Problems Refreshing
Hi there, Im currently using a 2019 version of excel. All my files are saved directly to one drive , however when i open old excel documents using one drive on my desktop (file explorer) , it doesnt just let me save the changes made . instead it…
ADODB Parameters: work independent from regional formats
Hi, I'm using an ADODB.Command object and it's Parameters property to insert records into an Access database ("insert into table (...) values (...)"). One of the table fields is of type Currency. The corresponding ADODB.Parameter.Type is…
Is anyone having issues creating, running or recording Office Scripts in Excel?
've been using Office Scripts in Excel to automate some tasking. Yesterday, I tried to add a new script and it gives me the following error. Oops, something went wrong An unexpected error occurred. Click 'Refresh' button to retry. I also tried 'Record…
How Can I delete #REF! Error in Conditional formatting Manage Rule. It Become my worksheet Slower.
How Can I delete #REF! Error in Conditional formatting Manage Rule. It Become my worksheet Slower.
Excel Visio Data Visualizer add-in - Not working on Office 2019
Hi all, I am not able to use the 'Visio Data Visualizer' excel add-in. When attempting to open it, it just brings a white screen.
How to Set Excel's "Find All" Feature to Search Entire Workbook by Default Instead of Current Sheet?
I'm trying to adjust Excel's "Find All" feature so that it searches the entire workbook by default, rather than only the current sheet. I’ve researched this and found that there are third-party tools and VBA macros that can accomplish this, but…
Excel forumla longer than 8192 characters
I have a Excel worksheet that is 5490 columns wide in a shared workbook. When I save the file with zero columns hidden I do NOT get this message. When I hide every 11-15th columns it will work until I get to column 4245 approximately. After that I get…
SSIS package that supposed to export data from SQL to Excel stopped working after upgrading to SQL2022
Hello. We have multiple SSIS packages that import data from Excel into SQL and export results back to Excel. All those SSIS packages were designed in VS 2012, connecting to SQL 2012 and Excel 2013, and we can run it successfully as a part of SQL job or…
How to fix multi conditional formatting issue-- dates
I am attempting to color code Board Member terms based on how many years they have left. I am using conditional formatting formulas to attempt this, but something isn't working correctly.
Why do these cells in Excel stay green and cannot be changed?
I have a spreadsheet that my team uses in excel that we share on the web browser and use chrome. When we try to insert new cells they show up as white until we enter txt into them, and then they are hgihlighted as this green color shown below. But we…
Unable to set any property when protecting an excel worksheet using pywin32
Hello, I am using pywin32 for a project to automate a few excel files using python. In the excel file, I want to protect all the cells that contain a formula. So, I first unlock all the cells and then only lock those cells which has a formula. When I…
Dialog box blocking access to Excel
Every time I try to open an Excel file, a dialog box opens asking me to save the file. I do, but it pops back up. I hit cancel; it pops back up. Tried repair and reset, still pops back up. I have to use task manager to get it to shut down even. I have…
How to copy and paste a macro into various tabs making minor adjustments to the code.
I have a workbook that has tabs for each day of the year. The tabs are labeled as the day they correspond to. I want to lock each tab at midnight to prevent accidental changes to the the data. I have the macro code for the locking by date and time. Can…
Excel JS Addin - Offline availability of full application with taskpane and custom functions
Offline access to Excel Add-in with MSAL and custom functions Description We are about to develop an Excel TypeScript Add-in that should replace an existing .xla add-in. This add-in has two main functionalities: Provide custom functions to the Excel…
how to fix Excel LTSC 2021 install problem, error code 0-2048(0)
when I start the installation of excel LTSC 2021 I have an error message that comes out 0-2048 (0) I deactivated the firewall, I uninstalled all office products, I tested the installation on another machine, it gives the same error
How can I add Excel Notes to cells with the Office Javascript API?
Can support for this be added if it doesn't exist already?