Microsoft® Excel® for Microsoft 365 MSO (Version 2205 Build 5.20028) 32-bit I would appreciate any advice that people are willing to give! Most of the information I found was either outdated or ineffective. I tried looking at various support articles from Microsoft and different 3rd party forums, but to no avail. After going through this extensive troubleshooting process, it seems like the issue lies in Excel, but I don't know how to fix it. Still, nothing changed and I got the "document not saved" error.Īt this point, I have no idea what to do. Also in the Trust Center -> Macro Settings, I checked "enable VBA macros" and "enable Excel 4.0 macros when VBA macros are enabled". I went to Options -> Trust Center -> Trust Center Settings -> Trusted Locations and added the network folder path to the trusted locations, making sure that I used the server name, rather than the IP address (which would return an error), and checking the box: "Allow Trusted Locations on my network (not recommended)". I made sure that my Antivirus wasn't interfering with Excel file saving. It still failed to save to the network folder. xlsm file with a small name, such as "T1", to confirm that the problem wasn't due to the 218-character path limitation. I confirmed that my network connection was perfectly fine and I also made sure that I had proper permissions on the network folder. Make sure you are connected to the network and try again." xlsm file from the local computer to the network folder in File Explorer, but a "Network Error" message box popped up, saying that "there a problem accessing. xlsx) to the network folder and it saved successfully. I tried saving a different Excel file type (such as. xlsm file to the network folder, a warning message box pops up, saying: "document not saved".Įrror that pops up when attempting to save to a network folder xlsm files to my local computer (for example, the "Downloads" folder), however, I am not able to save the same file to a network shared folder. I am having an issue with saving macro-enabled workbooks (.xlsm) in Excel. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.So they refer to the new location and not keep referencing back to the original folder. That way wherever the MAIN folder is copied to, the macros in all the worksheets in the workbooks that are under that MAIN folder will refer to each other rather than the workbooks inthe original location at C\. Is there any way of getting the vba references to use the MAIN folder as its reference rather than the C:\ reference Instead of the new location C:\PROGRAMS\MAIN Then all the references in the macros will still point to C:\MAIN Now if the MAIN folder and iits contents gets copied from its original location The VBA reference in menu.xls worksheet in folder A worbook to worksheet contents.xls folderB workbook is I create a maro in a workbook under folder A which refers to a a worksheet in another workbook say under folder B. MAIN is on the path of the root directory C:\ I have several worbooks saved under separate folders.Īll the folders are saved under a main folder. I searched the posts but couldnt find an answer.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |