Saving Xlsm In Sharepoint Find Errors In Workbook

Next we edit a page on the SharePoint site. ‘We are updating Server Properties before save the file. xlsm format may contain all kinds of (insert suitable 4-letter expletive here). Re: Excel Vba code to get user name of opened file from sharepoint. VBA Sharepoint Check out & Check in - Please help a newbie!! to apply to a number of other excel files on Sharepoint at the same time? i. Solved VBS script open file, run macro but does not VBS script open file, run macro but does not save the Since we don't have a copy of your workbook(s) it's. SharePoint records these saves as new versions but no data in the file has been saved… 9 hours of work lost and an extremely frustrated customer. I had the exact same issue as mentioned in the article and resetting the application pool resolved the issue. Copying or moving files from one document library to another is one of the common scenarios in SharePoint when it comes to document management. I just need to be log on the server. How do I find out what the current User's desktop folder path is each time the Marco is run by a different User?. Click "Save" on excel and test server properties updated. 0' provider is not registered on the local machine. The best way to convert an XLSM file is to open it in one of the XLSM editors above, and then save the open file to another format. In SharePoint Server 2010, you can edit and save a workbook programmatically. My code tries to save to the spurious location and if it fails repeats the user request. Open() doesnt work Okay, I have now dug into the whole sharepoint online thing. Summary: In this Blog, we will go through Microsoft office most important product i. NET assembly bind failure Azure benchmark C# Certificate Change management comparison CS0501 CSOM css CSV Document Management Drupal Drupal Feeds Event Excel Services file input file upload forms Fusion log Games General HTC Huddle IIS InfoPath Information Management Java LaTeX Microsoft Microsoft. In the final step of the saving process, Excel deletes the original Excel workbook and replaces it with a temporary copy. If you are getting the Compile error can't find project or library, then follow the solution given in the article to fix it easily…. ClosedXML is a. Rory Theory is when you know something, but it doesn’t work. but, when we uploaded the xlsm file to Sharepoint site (2007) Issue: None of the users are able to open the xlsm files. To verify that a workbook is compatible with Excel 2013, 2010, or 2007, run the Compatibility Checker manually the first time you save your workbook. One of the methods is explained in the article Excel VBA. The Save As dialog box appears. To make the repairs in a new file, click Continue. "Errors were detected while saving '[path\Filename]'. A Blog about SharePoint, Development and IT related. Save a macro with the current workbook If you'll need the macro only in the workbook where you created it, click Save or Save As like you normally would. sheets, "test. Using Excel 2007 (xlsm) which is supposed to only be able to load read-only files, but that is not a problem. I now want to copy that zipped file to a sharepoint. For example, an XLSM file opened with Excel can be converted to XLSX, XLS, PDF, HTM, CSV, and other formats. 0) are supported, I suspect that the. xlsm file in your Excel Application?. For example: wb = openpyxl. If you have been following the multiple threads on issues and changes to the PowerPivot for SharePoint 2016 Gallery Snapshots, you may be aware of an issue where gallery snapshots do not function properly (infinite "hourglass") for SSL sites when there are multiple sites bound to the same port. At this point, you’ve tested the change case. Press Alt + F11 to open the Visual Basic Editor (VBE). " This issue impacts build Version 1707 (Build 8326. Any ideas?. xls) and for the new Excel 2007,Excel 2010, Excel 2013 and Excel 2016 (. These are the defaults used by XlsxWriter. If you want to save it any other stage you can simply use the Save method. This Professional. Or in other words, XLSM file is a spreadsheet that includes macros written in (VBA) Visual Basic for Applications language. I want to open this workbook, make some changes and save it under different name ("myworkbook_copy. xlsx extensions open quite happily and can be edited and saved back, but those with. Importing Excel spreadsheets to a SharePoint List can be done in three easy steps. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ Cancel as Boolean) a = MsgBox("Do you really want to save the workbook?", vbYesNo) If a = vbNo Then Cancel = True End Sub This example uses the BeforeSave event to verify that certain cells contain data before the workbook can be saved. Those with. This has been working like a charm for a long time. There are a number of ways to work around this: you can save the shared workbook with a different file name, you can share the workbook from code running outside of the current workbook, or you can simply display the SharePoint site and allow the user to reopen the shared workbook from there. After you run an Excel workbook that contains ActiveX controls (FM20. I open a new excel workbook and through Excel options, I install this add-in. xlsm of my project was corrupted. Follow these steps to save your workbook when running Excel 2010 on Windows XP: Click the File tab and choose Save. How do i overcome this problem. In this example we will see how to save Active Sheet and specific worksheet as new excel file using VBA. After performing some automated data manipulation, I want to save it as a new macro-free workbook (thus. Finally, the code makes the second sheet active and writes on it, saves the workbook and closes Excel. Maybe your line manager is checking a piece of information in a workbook, whilst at the same time you are trying to rename the file. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLE. Re: Access VBA to open, change & save excel file That is certainly a possibility, as there is likely to be some kind of caching in one or more parts of the operation. Here check out the complete information about XLSM file and how to fix XLSM file won’t open in Excel 2013 issue. The error seems to be quite simplistic, but you might need to do quite a bit to. Hey, I have got an excel file over sharepoint which i need to update through the macro. Q): How can I automatically refresh external workbook links after every 10 seconds? To update excel file every 10 seconds; we need to follow the below steps: We need to create two excel file 1)Source. Please follow the below steps to execute the VBA code to save as the excel file. You can save any workbook (with or without macros) in binary format. If you need to save a snapshot (a point in time) of the SharePoint data you should "Save As" an Excel Workbook (or some other static format). If you dont have links between slave worksheet and the master worksheet, then you need to write a macro to COPY the worksheet from the master workbook to your slave workbook. Kill Excel. using Save doesn't appear to do anything using Save As doesn't either do anything, the dialog is not displayed and if I am doing via the File menu then the File menu is exited and the previous ribbon tab is displayed (i. Saving early and often can prevent your work from being lost. All should work. Select Save to save the file in the new format and return to the current worksheet. This macro creates and opens the new Excel file 'test. com service and thus can be used to schedule refreshes of data within your company (if you already have a SharePoint o365 account). But we do have the action to update the whole file content in sharepoint library. Scenario: I need to update information in a lot of Excel worksheets. NOTE: When saving a file that contains macros, you must choose Binary (xlsb) or Macro-Enabled (xlsm) file format in the Save window. To cancel saving the file, click Cancel". when you try to load that on the server. using Save doesn't appear to do anything using Save As doesn't either do anything, the dialog is not displayed and if I am doing via the File menu then the File menu is exited and the previous ribbon tab is displayed (i. SaveAs "C:\Backups\accounts. xlsm and managed to crash it. Ron de Bruin is working for a company that is growing chrysanthemums (nothing to do with Excel) and has been an Excel MVP since 2002. If you want to save the active Workbook as a CSV file you use this command, that is, "ActiveWorkbook. Workbooks must be saved as. We can use Copy and SaveAs methods of Workbook to copy and save the sheet into new workbook. If you receive this message in SharePoint when attempting to use the Explorer View option you should try enabling the WebClient service (see below image): If you're unsure of how to get to your Services list simply go to Start, Settings, Control Panel and open your Administrative Tools then click on Services. Secondly, if you want to make OneDrive hourly refresh work after making changes to the Excel file, you would need to directly connect to the Excel file stored on SharePoint Online folder from Power BI Service rather from Power BI Desktop. There may be times when you need to ask the user to select a location to save a file. In SharePoint Server 2010, you can edit and save a workbook programmatically. xlsm', keep_vba=True). xls) and for the new Excel 2007,Excel 2010, Excel 2013 and Excel 2016 (. This functionality is even better if the user is given the opportunity to specify a path and file name. The best way to convert an XLSM file is to open it in one of the XLSM editors above, and then save the open file to another format. Then open it to save as xlsm which choose Excel Macro-enabled Workbook in the other directory. all the sheets are deleted and you remain with one sheet you write hhow do i write to new sheet in the same file wothout overwriting what is there? thanks. When we close the workbook we not delete the menu now. When you save the page you have two really nice looking Web Parts. FileInfo template. xlsx file which works fine. Any ideas on why I am suddenly getting this error?. Then set the Compatibility Checker to run automatically every time you save that workbook. This has worked well until recently when we are migrating to Sharepoint and users are trying to save the workbook to a mapped drive that is mapped to a Sharepoint location. xlsm (Workbook with blank templates). In my Excel workbook, I have few queries & connections from SharePoint. *** 1- Open SharePoint 2- Go directly to the folder where you would like to save your file. AskToUpdateLinks is used to disable the message. Most of the time, you’ll probably want to save your workbooks in the current file format (. Click Save to SharePoint. Excel Online has basic sharing options, while Excel 2013 allows you to customize editing permissions within a workbook, a worksheet or even whether individual cells can be edited or not. If you have SharePoint open in your browser, then just copy that link and remove anything added to the end that is not your folder (e. Save a packaged workbook – Saves the workbook along with all referenced local file data sources and images into a single file. To save changes you made to your document, copy the worksheets you changed to a new Excel document and save it. It is true that you cannot directly only add/update some rows to excel files that stored in SharePoint libraries. xlsb are available with the higher versions of excel 2007 ,2010 and above. *** 1- Open SharePoint 2- Go directly to the folder where you would like to save your file. UpdateLink, finally close the workbook. xlsm format may contain all kinds of (insert suitable 4-letter expletive here). I'm dividing a workbook in several stores. Excel - Close and Save active workbook in VBA with no Prompt Posted on November 5, 2011 by admin This VBA code will save an Excel workbook file and close it when it runs. I have a small sample there how to programmatically access SharePoint 2007 data using this component. In this article we will learn how to excel close workbook using VBA in Microsoft Excel 2010. GetSaveAsFilename Method to the workbook BeforeSave event. Add custom Visual Basic for Applications (VBS) code into the workbook. xlsm file:. I just need to be log on the server. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXM. Tried to print the new document and received the message “We didn’t find anything to print. Force users to save as. Save the workbook to SharePoint, open it in a browser and refresh data. Created a SharePoint 2013 library with an Excel content type. xlsx") # and of course you need to save it. Money details is stored in the "Data file" workbook. The Basics. xlsm' the active workbook, the command 'Workbook. Check the code names that macros use to refer to the workbook and worksheets (see the previous section above). 47 MB; Introduction. I cannot figure out how to take all those open workbooks and save them to another directory and close the workbook. The Summary workbook is then shared with end users using the centralised SharePoint portal. com Another way to save files to SharePoint is to create them from SharePoint! 🙂 Instead of creating new documents in Word or Excel on your desktop, you can use the “New” drop-down button and choose the file you want to create. I am open to any non-standard solution : SharePoint web service, capturing the HTTP frame when changing the parameter with the ASAP checkbox activated and replaying it later. This assembly sometimes creates performance issues. Following is the VBA Syntax and sample VBA code to Save Active Workbook using VBA. One of the methods is explained in the article Excel VBA. Excel is a real-time data analysis application and popularly used by the large as well as small business sectors for various purposes. I want to open this workbook, make some changes and save it under different name ("myworkbook_copy. In Excel 2007, save the workbook as a macro-enabled workbook that is named C:\Abc. Press Alt + F11 to open the Visual Basic Editor (VBE). This example utilizes several advanced VBA functions to export an Access table to Excel. And now it’ll open Excel, open the macro enabled workbook, run the macro, save the workbook with a new name and close Excel. 0' provider is not registered on the local machine. And now it'll open Excel, open the macro enabled workbook, run the macro, save the workbook with a new name and close Excel. Practice is when something works, but you don’t know why. Try to create another Excel files, save as. xls!Hello_World") then i got COM exception. In this example we will see how to save as the Excel workbook using VBA. There may be times when you need to ask the user to select a location to save a file. At the opening it gave me the error: TF208002: “The name that you specified for the column header is a reserved name for this work item list. This web site was created on 2003, with the scope to share a public informations. After the SaveAs, there should be two files existing with the same data but different names (and different file types if the user chose that). XLSB - but you can't use XLSX for VBA macros). One more great advantage of this method is that we first save the files in a Sharepoint Document Library, not on the local computer. When the ExcelSheet1. You may have to register before you can post: click the register link above to proceed. xlsm) in the original directory. Basically even when I do a simple macro recording to a workbook and save them as xlsm, I can't have one of it sheet copy to a new workbook. To save a workbook: It's important to save your workbook whenever you start a new project or make changes to an existing one. I however have an issue I have been unable to find the resolution to. c) Save it as. In this article we will learn how to excel close workbook using VBA in Microsoft Excel 2010. However, from time to time there will be those moments when that won't be enough and you just won't be able to work any longer with a slow and large Excel file. This article provides steps to edit the workbook, depending on the nature of the unsupported features in the workbook. xlsm) format. Unsupported features are contents or functionality in a workbook that prevents the workbook from being opened for editing or, in some cases, viewing in the browser. Find the string "DPB" and change it to "DPx". 0) are supported, I suspect that the. So what’s different in SharePoint Online?. Looking for VBA Code for Save As Copy but save a copy of a. Recovering a Corrupted Excel 2007 File | XLSX and XLSM Format An Excel 2007 file that I was working on recently became corrupted. But you can also tweak it to what you may also need. The spreadsheets with the. Save a packaged workbook – Saves the workbook along with all referenced local file data sources and images into a single file. Finally, click Import and all your data in the specific Excel spreadsheet will be imported. Click “Save” on excel and test server properties updated. xls (personal. This code works for the workbooks that have already been saved earlier. xlvbaproject. Save will save the currently active Excel Workbook. VBA Sharepoint Check out & Check in - Please help a newbie!! to apply to a number of other excel files on Sharepoint at the same time? i. 3) Check Visual Basic Editor (VBE). I have a list that creates a new item in the library mentioned in Step 1 via a workflow. It has been observed that installing this patch will break all the list functionality in your SharePoint 2013 farm. State machine stuck for all workflows In Nintex for SharePoint Hi everyone We have some workflows which had been running for 2 years without trouble But today, I. Saving a binary file as XLSX or XLSM will result in a larger file size - ceteris paribus - (with all Excel features stored in the file being the same) Myth: "My workbook doesn't have macros, so I cannot SaveAs in binary format" Wrong. Pingback: Having trouble saving doc in SharePoint 2010 back to doc library « shilatech. To make the repairs in a new file, click Continue. So this is the same command that you would use to save a file under a new name, then a space, and "Filename", so we have to give it a filename, ":=". Click the OK button to save your change. Q&A for Work. Pingback: Saving Office Documents on SharePoint 2010 Servers « Brutally Simple. But to avoid problems always better to declare the filename. With Excel 2003 we have only one extension which is. Save method is as follows: expression. If you close and then reopen the local workbook, Excel connects to SharePoint to get any changes that have been made by other users, as shown in Figure 4-2. xls workbook Getting started with Excel macros and user defined functions, and your personal. Private Sub workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) SynchServerPorperties End Sub *This code provide us when user save file , server properties would be updated. xlsm', keep_vba=True). This will synchronize SharePoint list and excel data. This code will save as the Active Workbook into location mentioned in the code. Sometimes the script would be to quick, thus I needed to add a start-sleep for 1 second, to make sure the Excel file is opened in Excel before I run the macro. Save under a different file type/workbook version. Formulas are the key to getting things done in Excel. SaveAs "C:\temp\test1. Open the original workbook in Tableau Desktop. Download: START Excel Workbook. 2) Make changes and save. To be more precise, the Excel file seems to be reverting back to an earlier version (we have major versioning enabled). all links (there were allot). My issue is that I need to export/import this macro to other workstations who may have the save to location mapped to a different drive letter. PROBLEM STATEMENT I have a manager request to have a sharepoint list or excel workbook incorporate an automatic capability descripted in this article, e. Unfortunately, Office doesn't display any warning for this repair activity during Save/SaveAs, even if 'UI errors' have been enabled in Excel Options (Advanced tab). This is a quick tutorial on how to load Excel files from a SharePoint page. If you receive this message in SharePoint when attempting to use the Explorer View option you should try enabling the WebClient service (see below image): If you're unsure of how to get to your Services list simply go to Start, Settings, Control Panel and open your Administrative Tools then click on Services. However, if the parent workbook is an. Learn how to save a file or workbook in VBA. The Basics. If you want to save it any other stage you can simply use the Save method. xlsm and managed to crash it. If you save the workbook, changes are saved locally and then sent to the server. In SharePoint, a library can hold, with a few restrictions, any type of document. But it still. Where do you wan to share this workbook? Generally, if you have one or just a few macros that you want to share with others, you can send them the workbook that contains it in an email message. xlsm) that provides added security. Pingback: Saving Office Documents on SharePoint 2010 Servers « Brutally Simple. I found this Post that explains how to consolidate files on your computer with Power Query (kudos to Bacon Bits). Hello, Whenever I want to edit an Excel file which is located in SharePoint folder and then save it, crash appears. I was wondering if a Flow could be built to refresh the Exc. I cannot figure out how to take all those open workbooks and save them to another directory and close the workbook. Some key code like below:. Click the Stop Recording button at the bottom left of the Excel window. Saving a binary file as XLSX or XLSM will result in a larger file size - ceteris paribus - (with all Excel features stored in the file being the same) Myth: "My workbook doesn't have macros, so I cannot SaveAs in binary format" Wrong. And now it'll open Excel, open the macro enabled workbook, run the macro, save the workbook with a new name and close Excel. Here is a post from someone with the same error, there are a couple of suggestions towards the end. The file size of a Microsoft Excel workbook may unexpectedly increase exponentially. The spreadsheets with the. 3) Check Visual Basic Editor (VBE). · There will be placeholders for the deleted (or moved images). This may also be a good time to introduce the two methods available to refer to the active. SaveAs "C:\Backups\accounts. If I refer to this function through this file Test. Manual Way To Fix Excel Saving File at Network Location Error: To fix the error, add PivotTableNetworkResiliency and NetworkResiliency subkey s in the registry by making use of the following steps: Click on Start > Run > in the Open box > type regedit and click “ OK ”. In the event Code provided resolves your issue, please mark your Thread as SOLVED. Since SharePoint 2010, Co-Authoring has been available for various Office products when the documents are stored either on your own SharePoint or on Office365. (SP 2010/2013). Re: Tableau - SharePoint Integration alex. Also, since the workbook contains the above macro, if it hasn’t been saved as a. for using REFPROP within any spreadsheet in Office 2007 or 2010: Try saving the file as a macro-enabled workbook (under Save As…). you need to find the managed service account that runs the Excel Services Application Pool. Re: Sharepoint Online and Workbook. View 4 Replies View Related Power Point :: Hourly Data Refresh On SharePoint? Aug 28, 2013. e check out the file. I'm dividing a workbook in several stores. A quick search of. The keyword "List" specifies the GUID value for the desired SharePoint list (list=table) Query without specifying table names. Windows 10 sharing conflict when saving macro-enabled (xlsm) Excel 2007 workbook I have upgraded Windows 10 from Windows 8. In fact, it wouldn't help you recover any data from an Excel workbook. Activate' is used. Work with Sharepoint TM documents. It is very easy to rename a workbook or file in VBA using the below syntax. Q&A for Work. ActiveWorkbook. If I open one of those versions I get the same errors. What's the format you are trying to save to? If you save a. xlsx extensions open quite happily and can be edited and saved back, but those with. Most of the time, you’ll probably want to save your workbooks in the current file format (. To make things a little bit easier, I am trying to add a button that when the user clicks on it the file will save up to a sharepoint page. I do NOT have coding to call up the file I just zipped and move that newly zipped file to a sharepoint. xlsx files will also close without a warning dialogue. I'm dividing a workbook in several stores. My code tries to save to the spurious location and if it fails repeats the user request. If I open one of those versions I get the same errors. This website uses cookies so that we can provide you with the best user experience possible. This Access Excel VBA tutorial explains how to rename workbook or file in VBA using Name As. 20 Examples, including pictures, sample code, and downloadable files. The third step is to add custom code to the newly-created workbook that, when opened, will refresh the list data from SharePoint and save it as a new date-and-time-stamped Excel file in a desired folder on the PC or network. Private Sub workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) SynchServerPorperties End Sub *This code provide us when user save file , server properties would be updated. You can also make the workbook available on a shared network drive or from a SharePoint Services library. xlsm file in such a way corrupts it. In some cases the local copy is not cleaned up and can cause the problem you are getting. For this SharePoint Team-Site , You can provide a URL or connect to the root folder. "The workbook is currently open by 256 users. I've already saved a. xlsx and ExcelSheet3. Editing the data works fine but I have problems if someone using these sheets inserts another worksheet into them by copying them from another workbook with Excel by right-clicking on their tab in Excel and selecting the "move or copy" option for. xlsx file without Excel! These script cmdlet creates a Excel XLSX workbook file and stores the data of the objects that you submit in a worksheet within the workbook. Notice that the one on the right doesn’t have the menu bar. xls file, then it will be saved as an. What should be addressed is reliable having SharePoint receive the "I'm done with the file!" call from the Office client so it properly unlocks the file. Open() doesnt work Okay, I have now dug into the whole sharepoint online thing. What's the format you are trying to save to? If you save a. Technical introduction to Power BI limitations & considerations which hopefully will allow you to avoid most common implementation pitfalls. I want to open this workbook, make some changes and save it under different name ("myworkbook_copy. Getting started with macros and user defined functions, and your personal. xlsm" to the users My Documents 2) Open a prompt saying the user already has a file by that name in that directory Instead, I want the Save As dialogue to open. Save your Excel Workbook as a Static Image Workbook What better way to protect your formulas then to send an Excel Workbook with print screen images of each and every Worksheet? The VBA Macro will additionally save the copy of your file as an XLSX file which means all VBA Macros will be removed as well. To save changes you made to your document, copy the worksheets you changed to a new Excel document and save it. NOTE: When saving a file that contains macros, you must choose Binary (xlsb) or Macro-Enabled (xlsm) file format in the Save window. But saving a workbook with macros is a little different because it needs to be in a special "macro-enabled" file format. Note 2 - In this method XVI32 Hex Editor, a simple disk editor software application has been used for cracking the password. It's always up to date With an Office 365 subscription, you get the latest Office apps—both the desktop and the online versions—and updates when they. test addDataFrame(x = sample. ods) format. Close the workbook where you pasted the binder orders, without saving the changes. The Basics. all the sheets are deleted and you remain with one sheet you write hhow do i write to new sheet in the same file wothout overwriting what is there? thanks. Open() doesnt work Okay, I have now dug into the whole sharepoint online thing. You may have problems when you try to save a Microsoft Excel workbook if one or more of the following conditions are true: You save an Excel workbook to a network drive on which you have restricted permissions. 1) Edit the document from SharePoint and make sure you check out the document to your local drafts folder. Many possible workarounds, but hopefully everyone can find one that works for them. for clarification here is my code of what iam doing. ” in the print preview pane. xlsm) in the original directory. Hi, I'm using Office 365ProPlus and have added a macro to my excel sheet to determine the last save date of this excel XLSM file. I had the exact same issue as mentioned in the article and resetting the application pool resolved the issue. So what's different in SharePoint Online?. ” Mr Excel has some good tips in this course on VBA Macros that you may want to look up. ActiveWorkbook. I've created a button on an excel sheet that when clicked will fire an excel macro to open the well familiar windows "Browse Save as" box and allow the user to save the file to his/her desired location. They are stored in the workbook in plain ASCII text, so you should be able to recognize the macro code and then copy it from the disk tool. xls using Excel. What I am basically trying to do is to save a copy of my 'master' file every time it refreshes Power Query and connected Pivot Tables The code stops on. Excel Formula Training. In this example we will see how to save Active Sheet and specific worksheet as new excel file using VBA. You'll also need to pay close attention to where you save the workbook so it will be easy to find later. j) Double click on it. Workbooks must be saved as. Then I convert this Test. outside the organization). Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ Cancel as Boolean) a = MsgBox("Do you really want to save the workbook?", vbYesNo) If a = vbNo Then Cancel = True End Sub This example uses the BeforeSave event to verify that certain cells contain data before the workbook can be saved. To make the updated workbook run on another machine, you must install KB2726958 and delete EXD files. WHen trying to open a excel file, it returns a (translated) message that sounds a bit like: "We are unable to open the workbook file in this browser due to the following non-supported actions: - Sharing of workbook. Private Sub workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) SynchServerPorperties End Sub *This code provide us when user save file , server properties would be updated. But when the external workbook is closed the formulas result in #Ref! errors. It means that when you create a calendar and share the link with all users. In both cases I have the same problem.