Go Back   Tech Support Forum > Microsoft Support > Windows 10 Support

User Tag List

Opening Excel 2010 files rather than excel office 365

This is a discussion on Opening Excel 2010 files rather than excel office 365 within the Windows 10 Support forums, part of the Tech Support Forum category. 1-New laptop with office 365 with free trial period. Office 2010 installed from cd and updated to latest version. I


Reply
 
Thread Tools Search this Thread
Old 04-07-2020, 01:40 PM   #1
Registered Member
 
Join Date: Aug 2010
Location: Granby, Qc, Canada
Posts: 101
OS: Windows 10 family



1-New laptop with office 365 with free trial period.
Office 2010 installed from cd and updated to latest version.
I copied my Xcel work books from other pc also win 10 but no office 365.
I can open the woRk books In Excel 2010 but any new file opens in xcel 365. I don't plan to suscribe to office 365.
I have tried to associate excel 2010 instead of excel 365 but can't find an option to do that.
If I uninstall Office 365t will the default applications point to the ones from office 2010?
2-For eazy access to Office 2010 programs I pinned them to the start menu. This seems to have moved the actual files very deeply
in the Program data section of Wndows explorer. Can I move them to a section such as programs?
StanleyGF is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old 04-07-2020, 08:14 PM   #2
TSF Team, Emeritus
 
spunk.funk's Avatar
 
Join Date: May 2010
Location: Los Angeles
Posts: 40,538
OS: Windows 10 64 bit

My System


If your not planning on buying 365, I would Uninstall it. All Excel files will open in Excel 2010.
The Default location of Microsoft Office programs are in C:\Program Files\Micorosoft Office\Office14. Office files are spread around Windows like AppData/Microsoft/Office but the actual program shortcuts are in Program Files not Program Files (x86) Putting shortcuts on the taskbar will not move the location of the Executable.
__________________
Please press the Like link to right of any post you found helpful.
spunk.funk is offline   Reply With Quote
Old 04-08-2020, 02:05 PM   #3
Registered Member
 
Join Date: Aug 2010
Location: Granby, Qc, Canada
Posts: 101
OS: Windows 10 family



Deleting office 365 did the trick. But a new problem showed up.
I am unable to open Visual basic editor. Error 7 Insufficient memory.. Where do I start looking?
StanleyGF is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old 04-08-2020, 02:45 PM   #4
Team Manager
Microsoft Support
 
Corday's Avatar
 
Join Date: Mar 2010
Location: Midlands of South Carolina
Posts: 26,001
OS: Windows10. In the past CP/M, DOS, Windows 95, 2000, 98SE, ME, Vista & Windows 7

My System


If you post the VB code, I'm sure one of our "experts" can tell you what the problem is.
__________________

The stability of an OS is in direct proportion to the stability of the user.
Corday is offline   Reply With Quote
Old 04-08-2020, 06:50 PM   #5
Registered Member
 
Join Date: Aug 2010
Location: Granby, Qc, Canada
Posts: 101
OS: Windows 10 family



I am migrating from an older pc running under win 10. I have a woekbook which contains shared macros. This works fine in the old pc (10 yeard old). Before I transferred this workbook I could open the VBA editor and see the macros associated with many open workbooks.
When I added the PERSONAL.XLSB workbook which contains 3 modules. I could see the macros it contains and execute them but I could no longer open the editor. Even with a new workbook with no included macros I can't open the editor.
The laptop I am migrating to has 8.0 gb memory, the old pc has 6 gb.
Is there something that limits the memory assigned to excel?
StanleyGF is offline   Reply With Quote
Old 04-08-2020, 09:04 PM   #6
TSF Team, Emeritus
 
spunk.funk's Avatar
 
Join Date: May 2010
Location: Los Angeles
Posts: 40,538
OS: Windows 10 64 bit

My System


This might be caused by a corrupt VBA registry key. Open your registry editor by Pressing the Windows Key+R, in the RUN box type regedit and press enter. Then navigate to the registry key below and delete it. When you try to run the VB editor again a new registry key will be created.

HKEY_CURRENT_USER\Software\Microsoft\VBA
__________________
Please press the Like link to right of any post you found helpful.
spunk.funk is offline   Reply With Quote
Old 04-09-2020, 07:19 AM   #7
Registered Member
 
Join Date: Aug 2010
Location: Granby, Qc, Canada
Posts: 101
OS: Windows 10 family



Have tried your suggestion, rebooted laptop but get same error. Unable to load VBE6EXT.OLB. When I press OK I get a second error message : Insufficient memory. All of this in french because I am running Win 10 in french.
StanleyGF is offline   Reply With Quote
Old 04-09-2020, 09:57 AM   #8
TSF Team, Emeritus
 
spunk.funk's Avatar
 
Join Date: May 2010
Location: Los Angeles
Posts: 40,538
OS: Windows 10 64 bit

My System


Press the Windows key+X choose Apps and Features. Scroll down to Microsoft Office. Make sure the only version you have installed is Office 2010. Double click it and choose Modify. Click Repair. If that doesn't work, and you have your Office install Disc, Uninstall Office and restart the computer then install from the disc. None of your documents or Emails will be Affected during the process.
__________________
Please press the Like link to right of any post you found helpful.
spunk.funk is offline   Reply With Quote
Old 04-09-2020, 01:32 PM   #9
Registered Member
 
Join Date: Aug 2010
Location: Granby, Qc, Canada
Posts: 101
OS: Windows 10 family


Smile

Only one version of office 2010, ran repair, VBA editor opens without error. Thank you .
StanleyGF is offline   Reply With Quote
Old 04-09-2020, 04:24 PM   #10
TSF Team, Emeritus
 
spunk.funk's Avatar
 
Join Date: May 2010
Location: Los Angeles
Posts: 40,538
OS: Windows 10 64 bit

My System


Excellent! Glad you got it sorted. You are most welcome.
__________________
Please press the Like link to right of any post you found helpful.
spunk.funk is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Post a Question


» Site Navigation
 > FAQ
  > 10.0.0.2
Powered by vBadvanced CMPS v3.2.3


All times are GMT -7. The time now is 07:51 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.1.0 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Copyright 2001 - 2018, Tech Support Forum

Windows 10 - Windows 7 - Windows XP - Windows Vista - Trojan Removal - Spyware Removal - Virus Removal - Networking - Security - Top Web Hosts