User Profile
Michael1105
Brass Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: Need Help with Error
HansVogelaar, thank you very much for replying to my post. I apologize for the late reply to you. I wound up figuring out what the issue was. It was in the VBA coding that was causing the error. I opened the file in Safe Mode and fixed the code. Thus far the file is able to be saved without issue. Thank you again for replying. I appreciate you taking your valuable time in assisting. Have a wonder day.Need Help with Error
Hello. I'm hoping someone can help with this error. I'm not sure why this error is occurring because I haven't changed anything in this book regarding Active X Controls and this is happening with multiple files of the same type originated from a template that I've created. I've attached the screen print of the errors. These are the steps I've taken to save the file: Click: File-Save As Save As window appears Name file, choose Macro Enabled Workbook Click Save Error message appears: Errors were detected while saving... Click: Continue Save As window appears Click: Save Error message appears: Excel encountered errors during save.... Click: Ok Repairs to 'file name' box appears Click: Close File does not save. I click Save and the same thing happens.Issue with saving Macros Personal Macro Workbook in the startup folder must stay open for recording
Hi, I'm hoping one of the Excel gurus can assist me with this issue I am suddenly having with Macros. Suddenly all of the macros I had saved and have been using have dissappeared. I had these Macros set up in a tab and would just click the macro for the job I was running and it would format my document accordingly. As everyone knows, this saves a significant amount of time. Why this happened, I don't know. The only option now is to rebuild them. This is the process I'm doing to rebuild them: Developer tab Record Macro In Record Macro Box Name Macro Store macro in: Personal Macro Workbook Click: OK Error Message Returned: "Personal Macro Workbook in the startup folder must stay open for recording." I don't know how to get this Personal Macro Workbook to open. I thought that this workbook would automatically open at the start up of Excel. This glitch has caused me so much time and energy that it has actually put me behind in my work. I've checked the path and the "Personal.xlsb" file is in the XLSTART folder.Repairs to File error message explanation
Hello, I'm hoping one of the experts out there can assist me in letting me know how to find out what the Repairs to 'file name' error is that suddenly began to pop up after adding a new location to one of my worksheets. I'm not doing anything fancy. All I'm doing is copying a grid from one of our branch locations and pasting the copy to the worksheet for a new branch office we are opening. This is the error information that was logged: <?xml version="1.0" encoding="UTF-8" standalone="true"?> -<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <logFileName>error268680_01.xml</logFileName> <summary>Errors were detected in file 'X:\Working-On Projects\2023-Credit Union Goal Scorecard-Monterra.xlsm'</summary> -<removedRecords> <removedRecord>Removed Records: Object from /xl/printerSettings/printerSettings7.bin part (Print options)</removedRecord> </removedRecords> </recoveryLog> I have no idea how to find this error to fix it within the worksheet and I'm afraid this is going to affect the overall performance of the sheet. This workbook is a Goal Scorecard for the Credit Union where I work and the numbers need to be reported accurately to upper management. Can someone please assist in this request? I would greatly appreciate it. Thank you in advance.Re: Need an explanation on Compatibility Checker.
HansVogelaar Thank you for your response. This is strange because this is what I get: In "Data" tab of ribbon-Connections section-->Edit Links Popup: Click: Break Link Popup: Click: Break Links: Popup returns Edit Links window with Source still there: Do you know what could be happening within my Excel software that would cause this to not break but within yours it does?
