Excel 2019

6 Topics

PowerShell Direct - Unable to open Excel workbook with Excel.Application ComObject
Hello All, Hoping someone may be able to enlighten me or provide an alternative. Running in a local PS session on a Win10 client with Office 2019 installed, I am able to run these commands, open, and use content from an xlxs file: $file = "C:\TestFiles\Test.xlsx" $excel = New-Object -ComObject Excel.Application $workbook = $excel.Workbooks.Open($file) <...more code here but not relevant to the conversation....> When I try to use the same command using PowerShell Direct on the host where the VM is running, I get this: <Enter-PSSession -VMName WIN10.....command already run and connected. User account connecting is a local administrator in the Workgroup joined VM...> [WIN10]: PS C:\Users\TestUser\Documents> $file = "C:\TestFiles\Test.xlsx" [WIN10]: PS C:\Users\TestUser\Documents> $excel = New-Object -ComObject Excel.Application [WIN10]: PS C:\Users\TestUser\Documents> $workbook = $excel.Workbooks.Open($file) Microsoft Excel cannot access the file 'C:\TestFiles\Test.xlsx'. There are several possible reasons: • The file name or path does not exist. • The file is being used by another program. • The workbook you are trying to save has the same name as a currently open workbook. At line:1 char:1 + $workbook = $excel.Workbooks.Open($file) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : OperationStopped: (:) [], COMException + FullyQualifiedErrorId : System.Runtime.InteropServices.COMException Yes, the file is there. No it isn't opened by another program. Not trying to save. Again, the commands work over and over when run in a local PS session. I'm leaning toward using the ImportExcel PS module but I'm not sure it will allow me to find formulas in a spreadsheet (I've not seen where that can be done). Regardless, I've repro'd this on three different Hyper-V servers and it seems like there is a problem with ComObject. I'm not versed well enough to know much more than that. I've read about DCOM Config and allowing permissions to Excel but there are no entries for either Excel or a CLSID for Excel. This is simple for anyone to repro. Just have a Win10 VM with Office and create an Excel file. You don't need to do anything with the file. This all falls apart in PS Direct when the workbook is being opened. Thank you in advance for any help. Tom
Solved
Tom Phillips
Nov 23, 2023 Place Windows PowerShell
20KViews
0likes
3Comments
Power Pivot add in lost 2019HB
Power Pivot does not work in Excel. I tried to activate it as an add-on but it does not appear available. I looked in the Windows registry and nothing appears. I have Office 2019 HB installed so it should appear. The Power Pivot icon appears on the Data tab, but when you give it, it doesn't open any snow tabs or do any action. Just deploy the help that indicates what I've done, check com plugins and log
sistemassamca
Jan 23, 2020 Place Access
705Views
0likes
0Comments
Excel pro 2019 File/print/page setup/sheet/print titles disabled for different files, printers
Unable to select rows to repeat at top for my own workbook and for a new (empty) workbook on two different printers (MFC-L8900CDW and MFC-9460CDN. Tried File/print/page setup/sheet/print titles . Excel is pro 2019 on windows 10 pro. Sorry, I don't understand tags or l inks in this context.
Student-t
Oct 07, 2019 Place Excel
1KViews
0likes
0Comments
How to RANK, but changing the number of components being ranked automatically
I am trying to Rank a column using the following formula: =((RANK(AS4,$AS$3:$AS900)/number_of_stocks)*100), however instead of the $AS900 component, I would like to vary the number of cells being ranked to a number of cells being determined by cell E4 (which changes, as I change another variable)….would anyboby be able to help me with this? Thanks
Solved
rick01
Oct 02, 2019 Place Excel
3.2KViews
0likes
10Comments
Excel PivotChart x-axis label cannot be change or set
Currently I'm using Microsoft Excel 2019 to do this PivotChart. I cannot set or change the x-axis label on the PivotChart.
Solved
Alex_Phang
Sep 26, 2019 Place Excel
1.9KViews
0likes
1Comment
Can't resolve Excel 2019 threaded comments
The page below explains how to resolve a Comment, but when I click the "..." the only option I see it to delete the comment. Can someone please explain to me why I can't resolve a threaded comment? Thanks https://support.office.com/en-us/article/insert-comments-and-notes-in-excel-bdcc9f5d-38e2-45b4-9a92-0b2b5c7bf6f8
atafete
Sep 18, 2019 Place Excel
5.3KViews
0likes
1Comment