Export to Excel (built-in SharePoint Online list feature), a bad user experience
User wants to export the SharePoint list to Excel. In a SharePoint Online list, the user have a button/dropdown to export (Export to Excel or Export to CSV). When the user select Export to Excel a file, query.iqy will be downloaded. This file will be marked as This file came from another computer and might be blocked to help protect this computer. This results in the pop-up when opened in Excel; We've disabled this file's data connection because it's coming from an untrusted location. If you trust the file's source, please move it to a secure folder, and open it again. (the file is not loaded) If the user Unblock the file (in file explorer), the user gets the following pop-up when opened in Excel; Microsoft Office has identified a potential security concern. Data connections have been blocked. If you choose to enable data connections, your computer may no longer be secure. Do not enable this content unless you trus the source of this file. (User is given the choice to Enable or Disable) When the user select Enable, the user have the data from the SharePoint list imported into a Excel workbook. How can I improve the user experience without sacrificing security? - Trust files in Downloads folder is a no go
Make Office programs save to onedrive local first rather than cloud first
We are having an issue with Excel and onedrive/sharepoint that when we are offline on customer sites with our surface pros. A VBnet program we developed with Excel saves its progress and generated pdfs to the cloud first: https://xxx-my.sharepoint.com which it can't do when offline, this causes the excel app issues because it hasn't actually saved its progress in our onedrives offline as it can't reach sharepoint to first. It is important that we can change this as a setting as issuing this program out to our field staff, we need to have it as user-friendly as possible and reduce the chance of errors occurring and confusing our team. We know you can save to the local onedrive explicitly first by going to 'browse' from the 'save as' which prevents the issue but we need to mitigate issues rather than provide more complicated guidance.
How to authenticate to SharePoint Online Site from Office scripts?
Hi Folks, I'm referring below document to run an office script for adding images to Excel Table: https://learn.microsoft.com/en-us/office/dev/scripts/resources/samples/add-image-to-workbook The image I want to add is stored in a SharePoint Library. The link to the images are available in each rows of the table. I'm able to get the URL, how can I fetch the image from that URL. I'm stuck at the authentication stage. What is best approach to connect to SPO via office scripts as I know it does not support native login popups? ThanksNeed to append Excel data from daily email attachment into a single Excel sheet in Sharepoint
Each morning, I receive an email with an Excel attachment that includes our sales data for the previous day. There is only 1 tab. The email always has the same number of columns, with headers, but there are a dynamic number of rows. I manually open the Excel attachment, and copy all of the data - excluding the header row - and then paste those results into an Excel sheet in Sharepoint. This provides me a running total for historical reporting. How can I go about automating this process so when the email is received, the data within the attachment is automatically appended to the central sheet in Sharepoint? Thanks for your time!How do I get the SharePoint document Version number into an Excel file
As the subject states, I am looking for a way to insert the current document version into the actual Excel file itself. I have content management/versioning enabled so that is up and running. Example: I would like to have the "2.0" in the actual TEST.xlsm somehow.
How do you update a SharePoint page with Microsoft Form submissions kept in an Excel file?
I am working on a SharePoint site used to track Change Requests. I am pretty new to using Microsoft services for this kind of use case, but after some struggles, I discovered that I can use a Microsoft Form to track new Change Requests on an Excel sheet that is located within the SharePoint directories. The issue that I am experiencing is that I cannot pull live data from the Excel file. My objective is to have a SharePoint page named "Schedule of Change" which lists the Change Requests from the excel file on the SharePoint site itself. For example, if a user fills out the Microsoft form and a new row with this submission data is added to the excel file, the SharePoint site should also see this and add it to the Schedule of Change page. In other words, I want the content on the Schedule of Change page to stay up to date with the content of the excel file. I am pretty open to how the info is presented. Ideally, I would like to have a table on the Schedule of Change page where each change request is a new row, but if this isn't possible, then I will take what I can get. What I've Tried I attempted to create a list from an excel file, however it only pulled the data once upon list creation, and it would not update when any new change requests were made. I also researched this issue on the Microsoft forum and found some pages that recommend creating an automation, but the instructions didn't match what I saw and I wasn't able to automate this successfully. Can anyone provide instructions on how to read excel rows and add them to a SharePoint page even as new data comes into the excel form?[Solved] Display Version number into excel files from SharePoint WITHOUT turning into Macro enabled?
[Partially Solved] Apparently, the easiest way is to do a flow automation, that can update a row in Excel ======================= I've managed to put version number in all docx files, but I haven't found a solution online to display the current file version in an excel file that's displayed on the SharePoint libaray. I've found posts about creating VB codes, but that will turn all excel files into Macro enabled versions which is what we try to avoid. Can anyone share any thoughts or point me to the right direction please, thank you
Uploading large Excel files to sharepoint online lead to corrupt excel files with CustomXML deleted
When we upload the Excel Workbook with large CustomXML files (larger than 5mb?) to sharepoint via shared drive or sharepoint online (both reproduced). After the Workbook is synced it opens in Excel with a corrupt message. Also when unzipping it gives an error, to reproduce: rename the .xlsx to .zip and unpackage all files. One file could not be extracted, with: Zip Files Error . Could anyone provide a resolution or workaround for this issue, is there a certain limit to how large CustomXML should be?Excel in OneDrive does not update real time the linked numbers refreshed in the Excel application
Our team created this Excel file that we used to update every month and I used my OneDrive to share it to about 50+ people in our department. This file has linkages to an offline database which gets updated daily. I am the file owner and the one responsible to refresh the Excel file daily with the new data from the database. However, every time I refreshed the file in the Excel application and simultaneously view it online in my browser, the updated numbers does not reflect 99% of the time especially if there are several people using the file. So the file in my machine shows the updated numbers but the online version the numbers have not changed so those other people using the file are still viewing the old numbers. But when I paste the updated numbers as values, it gets reflected immediately in the online version. Any help from anyone here who knows how to resolve this moving forward so we won't spend so much time pasting values or telling people to exit the file every time because I need to refresh it with updated numbers? Thanks a lot for any helpPowerApps: Records Not Overwriting From Edit Form
Hello, I have encountered an error with PowerApps that is new to me. This excel sheet is updated by the Edit Form attached below. Is there a way so that if input is passed through for an order number that already has a record, that record will be updated and overwritten rather than having a new record with a duplicate OrderNumber? Any help is appreciated, thank you!
