Excel Management

Import data from Web using login details

How do I import data from Web in excel using login details. It does not allow me to enter my login credentials. If anyone could provide me with steps that would be highly appreciated. Thanks Pasang

Fixing an office script to filter a list populated by xlookup formula

I'm writing an Office Script to click a button and further filter a list (which is already filtered via xlookup). I want the script to show only the employees who's training is out of date. I receive the "AutoFilter apply: The argument is invalid or…

Office Development

Office Development

Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.

3,735 questions

Sign in to follow

Excel Management

Excel Management

Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.

1,692 questions

Sign in to follow

It’s just hidden. This happens when you pick a SmartArt graphic layout with a limited number of shapes and you exceed this limit. If you switch to a different SmartArt graphic layout the information below the red X will reappear.

Hi Team, Am trying to create organizational chart for my company which was about 1.2k members count. I have pulled records from data source and tried to paste in MS Excel - Smart Art - Organizational chart. But i get only partial records being rendered…

Fix Date format

Hi there. I'm using windows 11. when I download any kind of report (excel/csv) the dates are getting mixed for some reason and I cant view them under the current year/month. for example there are many rows under may 2024 and some of them will go under…

Excel Map Chart with Roads or County Boundries

I'm using Excel 365 and creating 2-D Map Charts with US States, Counties or Zip Codes. I'd like to be able to overlay major roads or County Boundaries (for Zip Code Maps). It would be great if all I needed to do was to select the map and then go to…

Otra cuenta de tu organización ya inició sesión en este dispositivo. Intentalo de nuevo con otra cuenta.

mi office no me deja ingresar Correlation Id: 76bf7b82-af8c-5640-bd8c-c46d8a8d3b01 Timestamp: 2023-05-08T13:02:52.000Z DPTI: 0eb6fbfed0064a71e4f84f24bf3e853acbd48b6bed4f2bcdab4f7aef376e507e

Excel file with view permission won't open in desktop app got you don't have permission to open this file

Hi team, We granted a user view permission to an excel file. The user can open the Excel file from the web but encounters a "You don't have permission to open this file" error when trying to open it from the desktop app. Thank you for your help

When I create a module in VBA and I'm typing a line of code, it just closes, any solutions?

I'm creating a simple registration system in Excel, I open Visual Basic normally, but when I click on "insert" and then "Module", after 10s Excel closes.

how to combine all sheets in power query

The insertWorksheetsFromBase64() Excel api is missing capability to insert hidden worksheets

Currently we are utilizing  insertWorksheetsFromBase64() api for our plugin to insert worksheets into excel workbook. Our team would like to insert HIDDEN worksheets using insertWorksheetsFromBase64() Excel api. Is it feasible from your end to expose…

Office

Office

A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.

1,491 questions

Sign in to follow

Excel

Excel

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.

1,708 questions

Sign in to follow

Office Development

Office Development

Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.

3,735 questions

Sign in to follow

Excel Management

Excel Management

Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.

1,692 questions

Sign in to follow

Python dans excel

Does anyone know how to install Tkinter on Python in Excel ?

Python in excel timeout error acts as 30 secs when typing 1800+ seconds

So I'm trying to do long calculations in one cell with python in excel, but i bumped into the problem that, when I type 1800 seconds or more as the timeout delay in the settings, it automatically acts as 30 seconds. It's the same for all numbers higher…

"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."

One of the users receive this error. is this issue at our end or at microsofts ?

Date grouping issue pivot table - Excel

I am encountering difficulties adding grouping to date columns in a PivotTable within the attached Excel file. When attempting to drag any date column to the row area, the expected grouping by month, year, or quarter does not appear. Manually clicking…

import pdf to excel

why does only show up by the data tb to click get external data, not to get data, and get the option to get a pdf file?

frequent error when refreshing pivot table

When refreshing a Pivot table that is created from another worksheet, I get: An unexpected error occurred (file'pcminorobjcoll.inl', line 109, function 'PCMinorObjectCollection[class PCProperty.class NameHashSupport]::SetNameAndUpdateCollection') This…

disable Ease of access feedback options

Hello, We use Office 365 version 2006 (build 13001.20384) and we want to disable the ease of access option "Provide feedback with sound" for all out users. This option is default enabled. In Office 365 (version 2002 build 12527.20278) this…

why the left column of taskgroup is reduced in customui backstage with excel 2013

Hello everyoneI have a problem in excel 2013 with my additional menu in the bakstage (CustomUI)the left column is not resized customUI> <backstage> <tab id="tabb202401" label="mes tutos sur youtube"…

Visual Studio

Visual Studio

A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.

4,904 questions

Sign in to follow

Office Development

Office Development

Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.

3,735 questions

Sign in to follow

Excel Management

Excel Management

Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.

1,692 questions

Sign in to follow

how to get the PIVOTBY function working on my excel

how to get the PIVOTBY function working on my excel?

Excel Differences between two worksheets but worksheets have dependent columns

I need to find a formula that supports the ability to highlight differences between two worksheets. Each worksheet has the same two columns. Those two columns are dependent of each other in order for the information to be correct. I need the formula to…