Error - 2147417848 80010108 In
Contents |
360 games PC games run time error 2147417848 (80010108) Windows games Windows phone games Entertainment All Entertainment run time error 2147417848 80010108 automation error Movies & TV Music Business & Education Business Students & educators
"run-time Error -2147417848 (80010108)" Excel
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Run Time Error 80010108 Automation Error
Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All runtime error 2147417848 hotfix Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies
2147417848 Automation Error
of this site About Us Learn more about Stack Overflow the company Business excel vba run time error 2147417848 Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask run time error 80010108 excel Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign https://support.microsoft.com/en-us/kb/849179 up Why do I get run-time error -2147417848 (80010108) in excel 2013 most of the time I run UserForm? up vote 2 down vote favorite Task: I work in Excel2013. I tried to write in VBA a userform to add parameters into dynamic named ranges. All named ranges are held in one sheet and were created using insert>table. I select the range, http://stackoverflow.com/questions/36683612/why-do-i-get-run-time-error-2147417848-80010108-in-excel-2013-most-of-the-tim show existing values and get the new value. All went well untill I actually got to adding value to the range. Problem: Excel shuts down most of the time when I try to run the UserForm. Saying: "Run-time error '-2147417848 (80010108)' Method X of object 'Range' failed" with different methods ('_Default' last time I checked) at different stages of me breaking code down. Symtoms: After this line as I found I get the error: Cells(y, x) = v where y and x are integers and v a string I get from the userform. During the debug I checked all values are defined and have values. Moreover, Immediate window with the same numbers input manually (not as variables), works! It mostly doesn't work, though it did follow through doing the job. If somone could tell the reason why it breaks it would be greatly appreciated! Some of the captions and potential values are in Unicode in case it matters, though I tried putting it all in English as well. Private Sub UserForm_Initialize() ' Preparing all controls of UserForm Sheet2.Activate Me.LB_parameter.SetFocus Me.LB_parameter.value = "" Me.LB_elements.RowSource = "" Me.L_element.E
it might only happen on certain PCs and not others. Symptoms of Runtime Error 2147417848 When a Runtime Error 2147417848 occurs you will know right away as a pop-up style error http://wiki-errors.com/runtime-error-2147417848/ message will appear. You will also likely not be able to access Excel http://www.mrexcel.com/forum/excel-questions/791853-excel-visual-basic-applications-run-time-error-2147417848-80010108-method-refresh-object-workbookconnection-failed.html in the correct manner, or at the very least there will be some spreadsheets that will be affected by the error. Causes of Runtime Error 2147417848 This problem is generally causes as a result of using the Macro too many times. Usually, this overuse will result in pivot tables being created which then time error generates the error. Unfortunately, there is nothing that can be done about using the Macro as it is part of the program. Fixing a Runtime Error 2147417848 For this type of error, Microsoft has created what is known as a Hotfix. The Hotfix is an easy and quick solution that can be used to fix the Macro that is causing the problem. To obtain the Hotfix for run time error a Runtime Error 2147417848 execute the following steps: 1. Log onto http://support.microsoft.com/contactus/?ws=support 2. Conduct a search for Runtime Error 2147417848. 3. Find a knowledge based article regarding the Runtime Error 2147417848 in question. 4. Look for the “Hotfix download available” button and click to download. Follow the prompts given then restart your computer to make sure the Hotfix is applied properly. See Also Personal tools Namespaces Article Search Our Products Main Page Applications .Net Framework Error AOL Browser Errors Installer Errors Internet Explorer Macro Errors Media Player MS Outlook Network Errors Outlook Express Windows Live Articles DLL Errors Exe Errors Ocx Errors Operating Systems Windows 7 Windows Others Windows Vista Windows XP TuneUp Tips Browser Tuneup Computer Tuneup Pages About Us Cat List Support Contact Us Help Center How to Uninstall Refund Policy Legal Disclaimers Privacy policy End User License Agreement (EULA) Terms of use Copyright©2013wiki-errors.com.All rights reserved. Disclaimer: This website is not affiliated with Wikipedia and should not be confused with the website of Wikipedia, which can be found at Wikipedia.org. This website should be used for informational purposes only. About Wiki-Errors Contact us Help Center Privacy Policy Terms of use End User License
Forums Excel Questions Excel VBA -- Run-time error '-2147417848 (80010108)': Method 'Refresh' of object 'WorkbookConnection' failed Results 1 to 4 of 4 Excel VBA -- Run-time error '-2147417848 (80010108)': Method 'Refresh' of object 'WorkbookConnection' failedThis is a discussion on Excel VBA -- Run-time error '-2147417848 (80010108)': Method 'Refresh' of object 'WorkbookConnection' failed within the Excel Questions forums, part of the Question Forums category; I am getting this error on a workbook connections refresh that is done in VBA . I am using Excel ... LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Jul 16th, 2014,01:44 AM #1 jpmccreary New Member Join Date Jul 2010 Location Atlanta Posts 11 Excel VBA -- Run-time error '-2147417848 (80010108)': Method 'Refresh' of object 'WorkbookConnection' failed I am getting this error on a workbook connections refresh that is done in VBA. I am using Excel Professional Plus 2010 and Windows 7. The code is part of a complex workbook that has 20 sheets, 330 procedures and 8,326 lines of code. The module with the error modifies a connection to an Access database that contains customer information. The connection queries the database and retrieves all data for the customer being queried. Complete module below. The error does not occur every time the code runs. I have not found a pattern for when it works and when it does not work. On the Microsoft support site I did find the error code description: The object invoked has disconnected from its clients. Here is the incredibly odd thing. The query does complete, at least as far as I can see. All fields get updated. After the error, Excel begins to behave strangely. Selected cells are not highlighted and the formula bar does not update when clicking new cells (even though