You can now sync Forms response to Excel desktop
We are thrilled to introduce a powerful new feature in desktop versions of Excel that is set to transform your data collection process. With the latest update, you can now create a new Microsoft Form directly within an Excel workbook, linking the form to the workbook seamlessly. This feature, previously available in Excel for the Web, is now available in the Windows app, with Mac support coming soon. reate a new linked form from the Excel desktop app This new integration is particularly beneficial for users who frequently collect data from other people. By enabling the creation of a form directly from an Excel workbook, you can streamline the data collection process, making it more efficient and less prone to errors. Whether you are gathering survey responses, feedback, or any other form of data, this feature ensures that all information is centrally located and easily accessible. For example, consider a team working on a project that requires input from multiple stakeholders. Using this new feature, the project manager can create a form to collect updates and feedback, and all responses will be automatically reflected in the project’s Excel workbook. This eliminates the need for manual data entry and consolidation, saving valuable time and reducing the likelihood of errors. How it works On the Insert tab, select Forms > New Form A new browser tab will open, presenting you with a blank form to customize according to your needs. Simultaneously, a linked table will appear in your workbook, ready to sync with the form. As you edit the form or receive new submissions, the linked table in your workbook will automatically update, ensuring that your data is always current and accurate. After creating your form, you can access several other capabilities from the Forms menu: **Preview Form:** This option will open the form in preview mode in a new browser tab, allowing you to see how the form will look to respondents. **Edit Form:** This option will open the form in edit mode in a new browser tab, so you can make changes to the form as needed. **Send Form:** This option will open the form in a new browser tab and show the dialog letting you send the form out to respondents and begin collecting responses. Availability and System Requirements The new Microsoft Forms integration is available to all Current Channel users running Version 2410 (Build 16.0.18227.20000) or later. You can check which version you’re using by going to File > Account. If you are using an earlier version, we recommend updating your Excel app to take full advantage of this feature. Mac users can also look forward to this integration in an upcoming update. Feedback We would love to hear your thoughts on this new feature! Please send any feedback and suggestions by selecting Help > Feedback.
Sending OneDrive Files Externally is not working correctly
We send OneDrive file links to external partners. I setup a test account with F3 licensing which is what these users have. Sending from my test account to a Gmail account, the Gmail account receives the email, clicks the link and enters the email address and one time passcode.... no issues opening and downloading the files. For other users, when they send, the link forces them to login into our tenant to download the file. The external user doesn't have a guest account in our tenant so they have an error. I don't understand why it's doing this for the other users and not my test account. All settings are the same for both users. Below are the default sharing settings in SharePoint admin. How can I fix this quickly? Thanks
OneDrive not syncing
Hi, I have added a folder to my OneDrive using a browser, waited for over an hour but it still doesn't show on my PC. OneDrive on my pc says "your files are synced" which is not true. Due to the general lack of verbosity in OneDrive, there is no way to tell when it will check again or when it hat checked last. Due to the lack of ease of use in OneDrive, there is no "sync now" button I would like to stop wasting money and continue my working day, what should I do? Regards, Robert.O365 - EU and China
Hi Worldwide Org - based in EU - they have a Tenant - and are about to migrate all users personal files from fileservers to OD4B - (into the EU data center) However there's a subset of users that resides in China - and apparently there's some China regulations saying data "must" reside inside China - (china users connection to the EU Tenant/OneDrive are very slow) so how do I solve this "architecture" in the best way possible? Multi-geo is not an option as China aren't supported. Does the Company create a SharePoint Farm in China and let the users in China have their OD4B on that - what about collaboration on documents, ediscovery etc. etc. between EU/China users in those scenarios? Does the company create a separate Tenant inside China and initiate the B2B capabilities in the EU tenant? How have others solved this?
OneDrive - the most annoying app ever
Hello, along with a new computer, I decided to switch from my older version of Office to a Microsoft 365 plan. I've been using OneDrive for a few years already like one uses any other storage device. What Microsoft did with OneDrive within the Microsoft 365 package, though, is pure annoyance. In fact, I'm momentarily tempted to cancel Microsoft 365 and install my old Office 2010 again. How can the developers think, any user would deem OneDrive the most important app ever developed in the whole universe? It's a storage device, people, not the cure for cancer, it's basically just a souped-up floppy disk. Why, then, does it push itself to the fore on all occasions like a prom queen with an inferiority complex? The options to control OneDrive are plain abysmal. I don't want it to track every single activity on my computer and suck up every bit of data, so it fills rapidly with pieces of crap data I have to delete by hand later, stealing me hours of lifetime. Above all else I don't want it to display just everything on every starting screen available. Aren't you guys ashamed even using the term "data privacy" when there's not even an option to get rid of that annoying "last used" folder on the Office 356 starting screen? I don't want my coworkers look over my shoulder and see I've just written an application, a resignation or a dismissal for Tom. That's basic data privacy! At it's momentary form, Microsoft 365 is more a problem than a solution for anything. Please, add some basic privacy options before you think about promoting this total indiscretion device. And find a solution for OneDrive to better control auto-save, so not every piece of junk data is stuffed to it.
How to move a Forms to OneDrive?
Hello, An user has created a Forms directly with the app Forms, so now when she wants to open answers in Excel, she has to download a file and there's no excel file in OneDrive. Is it possible to "move" it to OneDrive so she can open answers in Excel Online? Or maybe make it as a Template and then create a new Forms in OneDrive and use it..? I can't find any solution... Thanks for your help!User constantly prompted they need to request access to OneDrive shared item
Hello everyone! I have one specific user in my tenant who is unable to access files shared with them by their manager, (or anyone else for that matter.) They will continuously be prompted to request access to the item, which even granting direct access as opposed to sharing the link with them will loop them back to the same page. I took control of the manager's OneDrive directory and direct-shared the file myself to the user with no success and the same SharePoint access prompt. I additionally shared a file of my own for testing purposes, though this leads them back to the same page. All files within their own OneDrive on the app and on the web sync fine, they can also share files with other users---they just are unable to open anything shared with them. If this makes any sense? Has anyone encountered this and if so anyone have any suggestions for a solution? tldr; anyone who shares anything with one particular user they can't open it no matter what. Thanks. -Tristan
OneDrive Data Location
Dear Microsoft 365 Business Experts, Thank you for reading this question. I have created my Microsoft 465 Business Basic account (.onmicrosoft.com) and I chose Canada as this account's country. When I logged into Microsoft 365 admin centre, under Data Location, the Exchange Online and Microsoft Teams' data is stored in Canada, which is good. However, when I check OneDrive, it doesn't specify the data's geographical location. Is there a way to set the data in OneDrive's geography to be in Canada? The company I am working for requires all the data to be stored in Canada. Thanks!
Does OneDrive for personal account work yet?
I have been using Dropbox to sync my Word and Excel files. The reason so is because Dropbox allows me to choose what files I want uploaded where I can create custom folders to store them in. The last time I activated OneDrive, it began to upload ALL my files from my computer, including big video files. When I aborted the upload, all the files being uploaded were lost. Luckley I had them backed up on a local drive, but to suffice to say that I am hestitant to use Onedrive again. Has Microsoft finally updated Onedrive to allow users to determine what files they want uploaded and where? Will mt files be safe from being lost? If not, I am thinking of moving to Google or Zoho platforms becauseI have doubts that Microsoft understands how cloud storage actually works for non enterprise platforms. Thoughts please.
Microsoft 365 login
Hi folks, I can't login into my Microsoft Account from any Office 365 application on my Laptop. I can login to my my Account in any Webbrowser, on my Smartphone and so an. Unfortunatly there is no working Microsoft Support System for this problem. Instead there is an infinite support loop, which gets me in between a repair tool, that cant find any problems with my account and wants me to change my password. Anyone any idea how to fix this? thx
