Excel

1 answer

How do I save only tabs selected in a list box in a single pdf?

I have a list box that contains the names of all the tabs in the Excel workbook and the following macro to do a print preview: Sub print_sh() Dim i As Long, c As Long Dim SheetArray() As String With ActiveSheet.ListBox1 For i = 0 To .ListCount - 1 If…

asked

Dennis Psota 0

commented

Barry Schwarz 3,746

0 answers

VBA - How to extract/convert data from PDF file into excel file using VBA coding

Good day, requesting for your help on how to extract/convert data from PDF file into excel file using VBA coding.

asked

Eliza O. Riva 0

0 answers

Problems with SQL Server Data Connections in PowerPivot

Microsoft Windows 11 Enterprise, Version 10.0.26100 Build 26100 Excel Version 2108 Build 14332.21040 When executing queries against SQL Server 2012 databases in PowerPivot using the default SQLOLEDB provider that contain temp tables (#<tablename>),…

asked

Jeff 0

commented

Erland Sommarskog 120.6K MVP Moderator

0 answers

Azure DevOps Office® Integration 2019 extension on mac

we have identified that the Azure DevOps Office® Integration 2019 extension is not supported on macOS so we require for that any alternative third party tool on mac OS

asked

Ashish Patil 0

1 answer

Want to make it so that a Pivot will show how many days a vehicle is used monthly rather than total journeys

So the scenario I am in in that my company has multiple vehicles which can be taken as part of a car pool. Some cars are more popular to be taken than others. At the moment, on a spreadsheet we manually record the journey number, date of journey, time…

asked

MJ 0

answered

riny 585

2 answers

When I close Excel, an empty Excel window opens again.

I recently upgraded from Excel 2007 to the 2021 version and since then, every time I use Excel and close it after saving, an empty Excel window automatically opens again. I have tried updating and reinstalling Excel, but the problem persists. I am…

asked

재경 이 10

answered

riny 585

1 answer

Linking data from an Excel file to a Visio file using SharePoint?

I am trying to use the 'Link Data' feature in Visio to link to an Excel spreadsheet located in SharePoint. Currently it is accessing the file through my OneDrive which means that when others with access to the SharePoint open the Visio file, the data…

asked

Jess 0

commented

CC 0

1 answer

uweflsdgfksdfku

I;lsdjfs;kdufhksdfbk;sdbfk;suhdfs;ufk;SFSHDK;FU Thank you.

asked

Kory Kinter 25

edited a comment

Kory Kinter 25

1 answer

Using a Function macro form another workbook

I have project with multiple workbooks. To simplify macro management, I created a workbook with a single empty worksheet where I store all my macros. When this workbook is open, I can execute any of the Sub macros while working in another active…

asked

Barry Schwarz 3,746

commented

Jens 0

1 answer

Using a Function macro form another workbook

I have project with multiple workbooks. To simplify macro management, I created a workbook with a single empty worksheet where I store all my macros. When this workbook is open, I can execute any of the Sub macros while working in another active…

asked

Barry Schwarz 3,746

commented

Jens 0

1 answer

I encountered an issue where the Excel file doesn't prompt for a password before opening.

I am using Office Standard 2016, but I encountered an issue where Excel files that were previously password-protected no longer display the password prompt before opening after updating to Windows 11 version 24H2.

asked

soottipun sangangam 10

commented

Dieckmann, Andre 0

0 answers

Microsoft Excel (Microsoft 365) freezes while booting

I have Microsoft 365 subscription and have been using it for may years. Yesterday, suddenly, I was not able to open any Excel files. Excel freezes while booting. It freezes when FUNRES.XLAM is loaded. I tried SAFE mode and disabled Analysis Tool Pack,…

asked

Chander Shenoy 0

edited the question

Pradeep M 8,660 Microsoft External Staff Moderator

0 answers

How to fix pivot table error in macro:

Going to debug the highlighted paragraph is as follows: ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "POS-SalesByOrderItems-(2825707)!R1C1:R405C10", Version:=8).CreatePivotTable _ …

asked

MariaMc 5

commented

abbyc124 0

0 answers

error037280_01.xml

error037280_01.xml Errors were detected in file 'S:\debertrsc\Debert Absenteeism\2025\absent report ft2025.xlsx' Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Whitespace expected. Line 2, column 2632246.

asked

Tammi Manship 0

commented

Viorel 121.7K

2 answers

How can I get screentips or equivalent on shapes in excel 365

Help please In 2023 I wrote a genealogy spreadsheet with macro buttons on the sheets. I added an icon for each button with a screentip describing the button's function. The screentips worked 2 years ago but some update on 365 has disabled them despite…

asked

Ken M Hanley 5

commented

Keith Bishop 0

1 answer

how to fix error message, sorry, we couldn't find C:\windows\System32\file name.xlsm. is it possible it was removed, renamed or deleted

i have an excel saved on the C:\windows\System32\ but when i try to open it brings the error message, is it possible it was removed, renamed or deleted. i also attached the error. i need support on how to fix this issue. thanks for all the support.

asked

Isaac Ataide Somaconjamba 10

commented

Staci Steele Tinney 0

0 answers

LTSC Office 2024 Excel freezes

I've recently installed LTSC Office 2024 and while using Excel, it frequently freezes. How do I repair this?

asked

Steve Hillary 0

2 answers

excell 2024 changing cell fter entering to a different number

Excel 2024 is changing a dash number 8-1 or a 5-6 or a 5-7 when typed into a cell changing it to a date, ( on the top menu the "number" , "general" is selected). If I change "general" to "text" it changes the…

asked

DS Med_954 0

commented

Viorel 121.7K

0 answers

Excel chart freezing

Good morning, when excel encounters a graph it freezes for a few moments slowing scrolling. Possible solutions? Unfortunately, I can't share company workbooks. Version 2504 (Build 18730.20168 Click-to-Run) on Windows 10

asked

Roberto Castelluccio 0

1 answer

How do i link a cell in excel to a word doc and keep they live

I have reviewed an answer to another users question, but cannot get this to work. I am trying to use a speadsheet to keep track of student payments for a class trip. I would like to create a word doc for each student that will automatically update as…

asked

Timothy Mangiaracina 0

commented

Stefan Blom 2,681 MVP

Filter

Content

3,845 questions with Excel-related tags

How do I save only tabs selected in a list box in a single pdf?

VBA - How to extract/convert data from PDF file into excel file using VBA coding

Problems with SQL Server Data Connections in PowerPivot

Azure DevOps Office® Integration 2019 extension on mac

Want to make it so that a Pivot will show how many days a vehicle is used monthly rather than total journeys

When I close Excel, an empty Excel window opens again.

Linking data from an Excel file to a Visio file using SharePoint?

uweflsdgfksdfku

Using a Function macro form another workbook

Using a Function macro form another workbook

I encountered an issue where the Excel file doesn't prompt for a password before opening.

Microsoft Excel (Microsoft 365) freezes while booting

How to fix pivot table error in macro:

error037280_01.xml

How can I get screentips or equivalent on shapes in excel 365

how to fix error message, sorry, we couldn't find C:\windows\System32\file name.xlsm. is it possible it was removed, renamed or deleted

LTSC Office 2024 Excel freezes

excell 2024 changing cell fter entering to a different number

Excel chart freezing

How do i link a cell in excel to a word doc and keep they live