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. These objects are fictitious and I need to remove them. However they do not appear any …

Oddly enough, if I close the file and open it on my laptop, I can refresh without issue. In fact, sometimes when I close excel and open it back up, I can refresh the tables fine.

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 365, …

Hi. Running Server 2003 and XP Professional at the local machines. I have a shared folder on the server. In the shared folder are notepad files. When a user at a XP professional machine clicks on …

You are correct. When opening a Word or Excel file from User A computer the file is not locked. So other users can open and edit the file at the same time. I apologize. I didn't clarify... these files are on a …

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 Powershell script …

Jan 15, 2017 · At the last 2 weeks we having issues with the documents that at the Sharepoint once we trying to open any file (word,excel,ppt) we are getting the msg "We opened this workbook read-only …

I am trying to clear a temp xlsx tab, then move a tab with data into that temp tab, then move the range to a csv file. I have gotten everything to work (with some help from this site).

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.

How do I go about adding to a query a start and end date to limit the amount rows of of data that gets returned. We use MySQL ODBC5.1.