Previously, each month, I would unshare, unprotect and update the workbook ready for the new sales month. I would then protect the sheets and share it on the network for other staff to use. …

We had a somewhat similar situation, where Excel files were disappearing from folders that were being replicated. In our case it was with users that had enabled workbook sharing in Excel. In …

The issue I have is having to include the Excel macro-enabled spreadsheet in the script location so I can access it from the script. Is there a way to somehow embed the VBA script in the …

Jun 26, 2012 · The code below takes a CSV file (a table) and creates an excel file with pivot tables. I am having trouble iterating through all the PageField items with PowerShell.

Jun 4, 2014 · I have 4 Excel spreadsheets all with different formatting and column names that I want to use powershell to import into ONE Sql Server Table that I will want to create with …

Having macro defs in the personal.xlsb file in the xlstart folder causes the red [X] to close the workbook but not exit excel; it takes 3 clicks to kill the prog.

Selected Business Data> Excel Web access. Selected the workbook present in my shared documents and in the 'named item' i gave 'MyPivotTable' so that the pivot table in my excel …

Hi guys.I have used the script below to remove column (first 4 Columns) and row (first 13 rows) and it has worked.However, now I am testing the same script in a new excel file with a button …

I have an excel file that when I open it attempts to connect to external links to items that it thinks are in a sharepoint.

When I try to open a Excel file from any directory using Windows Explorer, it won't open. I get the loading screen from Excel, but opening a blank file. The file can be created in Excel Office …