Showing posts with label Office 2010. Show all posts
Showing posts with label Office 2010. Show all posts

Thursday, December 31, 2020

How businesses can save money when everyone needs Office to work from home



 Companies have scattered to the wind, once-formidable armies of workers enclosed in glass buildings now sundered, each employee at his or her own outpost, whether kitchen table, home office desk or lap in a quasi-quiet corner.

Flinging employees off the workplace carousel may have been as simple as a single "Go home" order, but ensuring that those workers can do their work from home and be productive at it (or even partially productive), takes work — a lot of work.

The suddenness of the exodus from the office may also have left management, IT and even employees unprepared for the shift. Core and work-critical tools, Microsoft Office among them, may be missing. But money doesn't grow on trees, not in times of cholera or coronavirus.

Getting Office to sent-home employees won't be simple. If the firm has stuck with on-premises, perpetually-licensed solutions, beginning to hybridize infrastructure by moving some of it to the cloud will be rough. And if IT hasn't had a lot of experience dealing with remote workers, there's a steep learning curve ahead.

But there are ways to cut costs and save money when the first order of business is to get everyone working on business. Computerworld has compiled several of the best options, some for shops that rely on Office 2010, 2013, 2016 or 2019, others for enterprises partly or completely in on Office 365.

Stay healthy. Stay in business.

If your company relies on Office (perpetual)

Office's perpetual version is the one that a firm purchases once with an up-front payment, typically as part of a volume licensing deal. That payment provides the rights to run the suite as long as one wants, long after Microsoft stops serving security updates if you're willing to take risks. It can be installed on just one PC or Mac, and so is tied to that device, not to its current user.

That means if these devices stayed at the workplace when employees were sent home to work, there are no Office licenses available for the worker to install on his or her personal laptop.

Subscribe to Office 365 E1 or Office 365 Business Essentials

These two plans — the former for firms of all sizes, the latter only for companies that purchase 300 or fewer seats — are among the least expensive Office 365 subscriptions. Office 365 E1 runs $8 per month per user (when paid for in a single lump sum for an entire year; more on that later). Office 365 Business Essentials costs $5 per user per month (again, when bought in an annual lump sum).

Neither plan provides the desktop Office applications found in Office perpetual, instead offering the web versions of Word, Excel, PowerPoint and Outlook. Both also provide Teams, Microsoft's collaboration/video conferencing software, which many businesses have begun using — or are using much more often now — to communicate and meet with now-at-home employees.

The idea here is that these Office 365 licenses are considerably less expensive than purchasing, say, a second Office 2019 license for an employee to use during the crisis. And while the web apps are not the equal of the desktop applications, they should serve for the unknown-but-not-infinite time workers will work from home.

Pay on a month-by-month basis

No one knows exactly when it will be prudent to return to working in large groups. Even experts are wary of guessing.

With that in mind, it seems smart to pay for "bridge" Office 365 plans like Enterprise E1 or Business Essentials on a month-by-month basis, not in a lump sum for a full year.

Office 365 Business Essentials, for example, costs $6 per user per month when paid month-by-month (and thus with only a monthly commitment). If the work-at-home stretch for employees needing the plan runs nine or fewer months, then, month-by-month payments will save money over the annual rate and commitment.

Partake of free-trial offers

Small businesses that were mulling moving to Office 365 and its always-updated/rent-not-buy model before the COVID-19 pandemic upended everything — and are still pondering the change — should take advantage of Microsoft's free one-month trials.

Office 365 Business Premium, a subscription plan that includes the desktop Office applications — Word, Excel, PowerPoint and Outlook for both Windows and macOS; Publisher and Access for Windows only — costs $12.50 per user per month (when paid for in an annual lump sum) or $15 per user per month (when paid on a month-to-month basis). Microsoft offers a 30-day free trial to the plan for up to 25 users.

If your company relies on Office 365

Organizations already armed with Office 365 — the by-subscription service whereby customers pay Microsoft an ongoing fee annually or monthly for the right to run the suite and numerous services — have an edge when their workers get spread from here to Timbuktu. That's because the subscription is licensed per user, not per device, allowing each employee to install the applications on multiple devices, including personal hardware they have at home. (There are many more reasons to give Office 365 the advantage here, but that's enough for now.)

Get the Office each worker can use

Not everyone who has been suddenly told to work remotely will have a PC or Mac at home. But virtually everyone has a smartphone.

"The first challenge of shifting to working remote — especially on short notice — is being disconnected," Yana Terukhova, who leads product marketing strategy for Excel, wrote in a March 19 post to a company blog.

She then ticked off the mobile apps licensed to most users of Office 365, including the Outlook email app for iOS or Android, and the new Word-Excel-PowerPoint combo app for the two operating systems.

Even entry-level Office 365 plans, such as Office 365 Business Essentials, which costs $6 per user per month when paid on a month-to-month basis, include rights to iOS and Android Office apps.

Depending on the employee's role in the organization, a personal smartphone may be all someone needs to do the job — or a large portion of it.

Get Teams for free for employees without it

Although Teams is included with most Office 365 Business and Office 365 Enterprise plans, there are exceptions, including Office 365 Business and Office 365 ProPlus. And then there are the employees who aren't assigned an Office 365 license because of their work roles.

The company needs a way to communicate with everyone on the payroll.

Microsoft has a program called "Microsoft Teams Exploratory" that lets employees with an Azure Active Directory-managed email address request a Teams license. (The request must be initiated by the user; it cannot be claimed by an administrator for a user.) The no-charge license will be good until the company's next enterprise agreement anniversary or subscription renewal, during or after January 2021.

More information, including how administrators can manage the Teams license, can be found in this support document.

More Teams for free

Another way to equip employees with Teams — and other Office bits, including commercial rights to the web and mobile apps — is with a Microsoft free offer of Office 365 E1. The deal, which Microsoft first mentioned earlier this month, awards E1 for a six-month stretch.

The lowest-priced Enterprise plan — $8 per user per month when paid for in an annual sum — includes Teams, as well as online storage (OneDrive), email (Exchange), and the web versions of Word, Excel, PowerPoint and Outlook. Also part of the plan: Mobile Office apps for iOS and Android.

This offer is aimed at enterprises or other organizations with existing relationships with Microsoft sales or a reselling partner. "Contact your Microsoft partner or sales representative," said Jared Spataro, a Microsoft executive, in a March 5 post to a company blog.

Microsoft has also waived the usual requirements for its FastTrack support for the free Office 365 E1 trial. FastTrack will assist customers getting workers on board E1 from March through August of this year, the company said.

Tell workers to self-install Office on their PC or Mac

When employees suddenly at home freak out that they can't work without Office, then get on the horn with the also-working-from-home help desk asking what to do, the answer may not cost the company a dime. That's because an employee already covered by an Office 365 plan can self-install Office on his or her own Windows PC or Mac machine.

IT staffers can point users to this support document, which describes the steps of signing on to office.com, downloading and installing the suite.

Sunday, December 27, 2020

Word for Office 365 cheat sheet

 


Word has always been the workhorse app of the Microsoft Office suite. Nearly everyone who uses Office ends up using Word at some point, whether it be for writing memos, typing up agendas, creating reports, crafting business correspondence or any of a thousand other uses.

Microsoft sells Office under two models: Individuals and businesses can pay for the software license up front and own it forever (what the company calls the “perpetual” version of the suite), or they can purchase an Office 365 subscription, which means they have access to the software for only as long as they keep paying the subscription fee.

When you purchase a perpetual version of the suite — say, Office 2016 or Office 2019 — its applications will never get new features, whereas Office 365 apps are continually updated with new features. For more details, see “What are the differences between Microsoft Office 2019 and Office 365?”

This cheat sheet gets you up to speed on the features that have been introduced in Office 365’s Word for Windows desktop client since 2015. We’ll periodically update this story as new features roll out. (If you’re using the perpetual-license Word 2016 or 2019, see our separate Word 2016 and 2019 cheat sheet.)

Use the Ribbon

The Ribbon interface is alive and well in the current version of Word. Since it has been included in Office applications since Office 2007, you’re probably familiar with how it works.

In September 2018, Microsoft overhauled the way the Ribbon looks. It’s now flatter-looking, cleaner and less cluttered, and has high-contrast colors, which makes the icons and text on the Ribbon easier to see. The blue bar at the top has been reduced as well, with the tab names now appearing on a gray background. But it still works in the same way, and you’ll find most of the commands in the same locations as in earlier versions.

One minor change to the Ribbon layout is that there’s now a Help tab to the right of the View tab. And there are slight variations in the Ribbon’s appearance between editions of Word in Office 365. For instance, the Search box is located to the right of the Ribbon tabs in consumer editions but above the Ribbon tabs in enterprise editions.

To find out which commands live on which tabs on the Ribbon, download our Word for Office 365 Ribbon quick reference. Also note that you can use the search box on or above the Ribbon to find commands.

Just as in earlier versions of Word, to make the commands underneath the tabs on the Ribbon go away, press Ctrl-F1. (Note that the Ribbon tabs — File, Home, Insert and so on — stay visible.) To make the commands appear again, press Ctrl-F1.

You’ve got other options for displaying the Ribbon as well. To get to them, click the “Ribbon display options” icon at the top right of the screen, just to the left of the icons for minimizing and maximizing Word. A drop-down menu appears with these three options:

  • Auto-hide Ribbon: This hides the entire Ribbon, both the tabs and commands underneath them. To show the Ribbon again, click at the top of Word.
  • Show Tabs: This shows the tabs but hides the commands underneath them. It’s the same as pressing Ctrl-F1. To display the commands underneath the tabs when they’re hidden, press Ctrl-F1, click a tab, or click the Ribbon display icon and select “Show Tabs and Commands.”
  • Show Tabs and Commands: Selecting this shows both the tabs and commands.

And if for some reason that blue on the title bar is too much color for you, you can turn it white, dark gray or black. To do it, select File > Options > General. In the “Personalize your copy of Microsoft Office” section, click the down arrow next to Office Theme and select Dark Gray, Black, or White from the drop-down menu. To make the title bar blue again, choose the Colorful option from the drop-down list. Just above the Office Theme menu is an Office Background drop-down menu — here you can choose to display a pattern such as a circuit board or circles and stripes in the title bar.

There’s a useful feature in what Microsoft calls the backstage area that appears when you click File on the Ribbon: If you click Open, Save a Copy, or Save As from the menu on the left, you can see the cloud-based services you've connected to your Office account, such as SharePoint and OneDrive. Each location now displays its associated email address underneath it. This is quite helpful if you use a cloud service with more than one account, such as if you have one OneDrive account for personal use and another one for business. You'll be able to see at a glance which is which.

In the works: A simplified Ribbon

Microsoft is also working on a simplified version of the Ribbon for all Office applications. Like the existing Ribbon, it will have tabs across the top, and each tab will have commands on it. But it’s more streamlined and uses less space than the existing Ribbon.

For now, only Outlook for Windows uses the simplified Ribbon in Office 365. However, some users can get a preview of what it will look like in Word by going to the online version of Word. Use the slider next to Simplified Ribbon at the top right of the screen to toggle the simplified Ribbon on and off. If you don’t see the slider at the top of the screen, go to the Ribbon’s View tab and check the box next to Simplified Ribbon. To revert to the regular Ribbon, uncheck the box.

In the simplified Ribbon, all the commands are still there for each tab, but only the most commonly used are visible. Click the three-dot icon at the far right end of the Ribbon to show the rest of the commands in a drop-down menu.

In the Outlook desktop client, you can toggle between the streamlined and traditional Ribbon by clicking a small caret icon at the right edge of the Ribbon. We assume this will work the same way in Word, but at this point we have no details. We’ll update this section when the simplified Ribbon rolls out to Word for Windows.

Collaborate in real time

The biggest feature that’s been introduced in Word for Office 365 subscribers since 2015 is real-time collaboration. It lets people work on documents together from anywhere in the world with an internet connection, a feature that Google Docs has long had. Microsoft calls this “co-authoring.”

There are only three requirements for collaboration in Word for Office 365: You must be logged into your Microsoft or Office 365 account; the document must be stored in OneDrive, OneDrive for Business, or SharePoint Online; and AutoSave must be turned on.

To collaborate on a document, first open it, then click the Share icon in the upper-right part of the screen. If you haven’t yet saved your file in OneDrive, OneDrive for Business, or SharePoint Online, you’ll be prompted to do so. What happens next depends on whether your document is stored in your own OneDrive or with OneDrive for Business or SharePoint Online.

If your files are stored in your personal OneDrive, you’ll share documents via the Share pane. But if your files are stored in OneDrive for Business or SharePoint Online, you’ll use a newer interface that Microsoft rolled out to enterprise Office 365 users in May 2017. A Microsoft representative told us that the company intends to roll out the newer interface to consumers with an Office 365 subscription at some point, but it hasn’t announced timing yet. So we’ll give instructions for both interfaces below.

If your document is stored in your personal OneDrive: After you’ve saved the document to OneDrive and clicked the Share button, the Share pane will open on the right-hand side of the screen — this is command central for collaboration. At the top of the pane, type in the email addresses of the people with whom you want to collaborate on the document, separated by commas. As you type, Word looks through your address book and displays the matches it finds; click the person you want to invite. If you’re on a corporate network, you can click the address book on the right to search through your corporate email address book. If a person isn’t in your address book, just type in their complete email address.

ocument.

There’s another way to share a file stored in a personal OneDrive for collaboration: At the bottom of the Share pane, click “Get a sharing link,” and from the screen that appears, choose “Create an edit link” if you want to create a link to the file that will allow people to edit the file, or “Create a view-only link” if you want to create a link that will allow them to view the file only. Then copy the link, write an email using any email program, paste in the link, and send the email.

If you want to instead send the file but don’t want to let people collaborate on it, at the bottom of the Share pane click “Send as attachment.” You can then send the file either in Word format or else as a PDF. When you do this, it won’t reflect any changes you make to it after you send the file.

If your document is stored in SharePoint Online or OneDrive for Business: Clicking the Share button pops up a Send Link window. Here you can send an email with a link where others can access the document. 

By default, only the people whose email addresses you enter will be able to edit the document. If you like, you can click “People you specify can edit” to call up a “Link settings” screen, where you can expand access to anyone with the link, people in your organization with the link, or anyone who already has access to the file.

On this screen you can also uncheck the “Allow editing” box to set any of those permissions to read only. If you do that, you can optionally block people from downloading the file by toggling the “Block download” slider on. Finally, if you choose the “Anyone with the link” option, you can set an expiration date after which they won’t be able to access the file. When you’ve made your selections, click Apply.

Back in the main Send Link window, enter the recipients’ email addresses (as you type, Word will suggest people from your address book whom you can select), optionally type in a message, and click Send. An email is sent to all the recipients with a link they can click to open the document. Note that depending on how your IT department has set up permissions for users, you may not be able to send the invitation to people outside your organization.

(If you’d rather send recipients a copy of the workbook as an Excel file or a PDF, and thus not allow real-time collaboration, click Send a Copy at the bottom of the Send Link screen.)

To begin collaborating: When your recipients receive the email from you, they click a button or link to open the document, which opens in Word Online in a web browser rather than in the Word desktop client. Depending on a variety of factors, including whether recipients are signed into an Office 365 account, whether the file being shared is stored in a personal OneDrive or in OneDrive for Business/SharePoint, and whether the sender and recipient are from the same organization, recipients may or may not be able to start editing the document in their browser right away. Some users will have to click an Edit in Browser button first, and some will be able to choose between editing the doc in the browser or editing it in their desktop Word app.

The web version isn’t as fully featured as the client version — for instance, there aren’t as many formatting options and you can’t insert shapes, take screenshots, use mail merge, or use several other features. But for basic editing, it works fine.

When any collaborators open the document, you’ll see a colored cursor bar for each person that indicates their presence in the document. Each person gets their own unique color. Hover your cursor over anybody else’s cursor bar to see their name. Once they begin editing, you can see what each collaborator does as they do it, including deleting, editing and adding text. They see what you do as well.

Collaboration includes the ability to make comments at specific places in a document without actually changing the document’s contents. To do it, place your cursor in the document where you want the comment to appear (or select a word or phrase), click the Comments button in the upper right of the screen, and select New Comment. A new comment box appears in the right margin; type in your comment there. If you want to draw a colleague’s attention to a comment, @ mention them in the comment, they’ll receive an email notification with a link to the document.

Everyone collaborating can see all comments in the right margin. To reply to a comment, hover over it, click the Reply button, and type your response. There’s also a Resolve button that grays out the comment.

Be aware that how well real-time collaboration works depends on the strength of your internet connection. On slow or flaky connections, you won’t immediately see edits that other people make and they won’t see yours immediately — there will be a lag. So it’s always best, when possible, to have the strongest connection possible when collaborating.

If your document is stored in your personal OneDrive, the Share pane shows a list of all people currently collaborating on the workbook or who have been given access to it. If you don’t see the Share pane, click the Share button at the top of the screen to open it.

Double-click any name in the pane, and a screen appears that lets you communicate with them as you work. Email is always available, although that’s not particularly useful for simultaneous collaboration, since back-and-forth may take a while. Instant messaging and making voice calls using VoIP are available, but only via Skype and only if both of you are signed into Skype while you’re working on the document. Click the three-dot icon to the right of their email address, and you’ll be able to add the person to your address book, schedule a meeting with them, and add them to your favorites.

If the Share pane distracts you, click the X on its upper right and it goes away. To make it appear again, click the Share button at the top of the screen.

As noted previously, if your workbook is stored in SharePoint or OneDrive for Business, you won’t have a Share pane. But you can still see who has access to the file by clicking the Share button. In the Send Link screen that opens, click the three-dot icon in the upper right and select Manage Access to see a list of people who can access the file. Here you can change edit/view permissions, revoke someone’s access, or remove the sharing link altogether.

Search to get tasks done quickly

A very useful addition to Word 2016 was called Tell Me — basically, an enhanced search feature for finding commands in Word. Now renamed simply Search, it’s extremely helpful when you want to do a task that you haven’t done before or have forgotten how to do.

To use it, click in the Search box — for some Office 365 subscribers, it’s located on the Ribbon to the right of all the tab headers; for others, it’s above the Ribbon in the blue title area. (Keyboard fans can instead press Alt-Q to go to the Search box.) Type in a task, and you’ll get a list of possible matches. Click the task you want to get instructions on how to do it.

For example, I typed “address an envelope” and chose the “Envelope” result, and the screen you use for addressing envelopes appeared. When I typed in the more general query “write an essay,” it popped up a link to Word’s Researcher feature that lets you do research from right within Word, add sources from the research you find, and then cite the sources in the document properly. If you type in a query and hover your mouse over a result instead of clicking it, you’ll see a screen describing what you can do if you click the results.

It’s a big time-saver, because you don’t have to hunt through the Ribbon to find the command you want. And it remembers the features you've previously selected in the box, so when you click in it, you first see a list of previous tasks you've searched for. That way, tasks that you frequently perform are always within easy reach.

Search is gaining more capabilities, too. Some users of enterprise and education editions of Office 365 are now able to use the Search box to find people in their organization, SharePoint resources, and other personalized results from within Word. (These features are being rolled out in stages, so you might not have them yet.)

Sunday, December 20, 2020

How to Recover Unsaved Word Document in MS Word

 You are working on a Word document and all of a sudden it stops accidentally, the computer restarts automatically due to an error or without saving the document. It can be scary, especially if it is an important document and if you have already written a lot. The idea of ​​rewriting the entire document can be scary.

Recover Unsaved Word Document

However, there is nothing to worry about, as luckily there are many ways to get back a Word document without saving it. We are going to implement the methods about MS Word 2007 to 2019, so let’s have a look at

How to Recover Unsaved Word Document in MS Word

Method 1: Using Open in the File tab

Step 1: Open an empty Word file and go to the File tab at the top of the document.

Step 2: From the context menu, click Open.

Step 3: Now on the right side of the pane, click on the republished documents at the bottom of the document.

Step 4: In File Explorer, select the file you want to recover and click Open.

Step 5: Click the Save As button and save the document to the desired location.

So, now you have recovered the saved document. But, if you don’t get the option above, try another method.

Method 2: Using the Info option in the File tab

Step 1: Follow step 1 of Method 1 to go to the File tab.

Step 2: From the context menu, click Info. Then click on the Manage document on the right and select Recover Unsold Documents from the drop-down menu.

Now follow steps 4 and 5 of method 1 to retrieve the saved document and save it to the desired location. But if that doesn’t work, you can try the third method.

Method 3: Using AppData

Step 1: Press Windows key + R on your keyboard to open the run command. Now type AppData in the search box and press enter. This will open the AppData folder in File Explorer.

Step 2: In the AppData folder, copy and paste the below path and press Enter:

This will take you to the location of unsaved files in the AppData folder. Now follow steps 4 and 5 of method 1 to recover the desired file and save it to your preferred location. 

I hope now you can Recover Unsaved Word Document in MS Word after following the steps. If you are unable to do it after following the steps then you can call ms office helpline number they will help you.

Friday, December 18, 2020

How to Repair Corrupted Excel Files

 Excel is probably as important to most workers as dressing and eating. I use Excel a lot daily to do everything from managing finances to analyzing customer data. It is so powerful that it is hard to imagine life without Excel.

How to Repair Corrupted Excel Files

And that’s why it can be so terrible when you finish a damaged or corrupted Excel file! It all works and can be lost forever unless you are smart enough to make a backup.

Luckily, most corrupted Excel files can be recovered, you just have to try several different methods. If your Excel file is corrupt, there are some ways to fix it or at least to recover some data. Repair Corrupted Excel Files.

How to Fix and Repair Corrupted Excel Files

Method 1 – Run Repair

The first thing to try is to open it in Excel with the repair option. You can do this by clicking on File and then Open. In the Open dialog box, click once on the Excel file, and then click the small arrow next to the Open button.

Go ahead and click open and repair and you’ll get a message asking if you want to repair, which will retrieve as much data as possible, or if you just want to extract data, which will mimic formulas and values.

You can try repairing it first and see that it can recover the entire file, if not you can try extracting the data.

Method 2 – Save the file in a different format

If you can open the file successfully in Excel, you can try to save the file in various formats and then reopen them in Excel and try to save them as Excel workbooks.

Click on File and then click Save As. Choose SYLK (Symbolic Link) from the Save as type list and click Save. Then close the workbook.

Then click on the file and open again, but this time choose the SYLK file. To view the SYLK file, you may have to select all files from the type list files.

After the file opens, click on the file and then click Save As. Now you will choose Microsoft Excel Workbook and click Save. Note that saving in the SYLK format saves only the active worksheet. You must save each worksheet individually and repeat this process.

Apart from SLYK format, you can also save the file in HTML format. Once saved, open it again and try to save it as an Excel workbook. With the HTML format, you do not need to save each worksheet individually.

Method 3 – Change Recalculation Options

If you are having trouble opening the file, there are many other things you can try. First, try setting the recalculation option in Excel in the manual. You can do this by going to Tools, Options, and clicking the Calculations tab. In the Calculation section, go ahead and choose Manual.

If you are using Excel 2007 or later, the process is different. You need to click on the office button at the top left and then choose the Excel option.

Click the formula, then click Manual in the Calculation Options section.

Now try to open the corrupt excel file and see if it opens. Otherwise, read on!

Method 4 – Open in Word or WordPad

You can try to open a damaged Excel file in Microsoft Word or WordPad. To do this, you must first ensure that Microsoft Excel Converter is installed. You can download it from the Microsoft website.

Even if you can open the files, you will lose the chart sheet, dialog sheet, macro sheet, and all the cell formulas that will be lost. However, you should be able to see the data.

If you have macros, try opening the file in WordPad as Visual Basic code may appear in your module. You will need to search for “function” or “all”.

Method 5 – Link a corrupted file

In Excel, you can link one worksheet to another Excel workbook. You can try to use this method to extract data from a corrupt Excel workbook.

Click on the file then open and navigate to the folder that contains the corrupted file. Then click on cancel. Now go ahead and click on the file, then click on New and OK.

In cell A1, type = FileName! A1 and press Enter.

If all goes well, you should see the data in cell A1 of the damaged worksheet in cell A1 of your new workbook.

If yes, you can now drag the corner of the box and increase the selection to the number of rows and columns that are present in the corrupted workbook.

Method 6 – Use Excel Viewer

You can also try to download Microsoft Excel Viewer, which may be able to open the file for you. All of this lets you copy cells and paste them into a new workbook, but it’s better than nothing.

Method 7 – Use Later Versions of Excel

If a corrupted Excel file was created in Excel XP, Excel 2003, etc., try opening it in a later version such as Excel 2007 or Excel 2010.

As the versions grow, the ability of the program to recover the file also increases, so you may get lucky and be able to recover your file.

Method 8 – Delete Temporary Folders

At this point, we hope and pray, but it is worth it. You can delete the contents of the C: \ Windows \ Temp directory, and then restart your computer. Try opening the file again.

I hope you understand how to Repair Corrupted Excel Files after following the steps and If you still can’t open your Excel file, post a comment here and I’ll try to help! or you can call MS Office Customer Care they will help you.

Thursday, December 17, 2020

Microsoft ends support for Office 2010, bangs the Office 365 gong



Microsoft on Tuesday reminded customers that Office 2010 and Office 2016 for Mac have received their final security updates, as the suites have now dropped off the company's support list.

And as Microsoft has done before, the Redmond, Wash. company exploited the end of support to pitch customers on changing to the subscription-based Office 365.

"We'll no longer provide technical support, bug fixes, or security updates for these products, and organizations that continue to use them may face increased security risks and compliance issues over time," Jared Spataro, an executive in the Microsoft 365 group, wrote in an Oct. 13 post to a company blog.

Office 2010, a set of Windows productivity applications — notably Word, Excel and PowerPoint — debuted in April 2010 and received Microsoft's then-standard decade of support. Office 2016 for Mac, which was released in September 2015, was allotted only five years of support, the maximum for a Mac-based bundle.

Both are what Microsoft calls "perpetual" versions of its application suite, the term derived from the type of license the company sells customers. Buyers pay a one-time fee for the product, which is then licensed to operate on a specific PC or Mac for as long as the user wants, even after support has ended if he or she is willing to risk the lack of security patches.

Cue the choir, sing hosannas for subscriptions

Microsoft has released perpetual successors to Office 2010 — both Office 2016 and Office 2019 — and Office 2016 for Mac (Office 2019 for Mac). However, they received nothing more than a mention by Microsoft as possible replacements for the expiring suites.

Instead, the emphasis is on the Office 365 and Microsoft 365 subscription plans, especially the locally-installed applications, which formerly went by Office 365 ProPlus but were rebranded Microsoft 365 Apps in April.

How to Fix Microsoft Office 365 Error Code 30180-4

 www.office.com/setup: Fixed Microsoft Office 365 error code 30180-4 – Microsoft Office 365 brand provides productivity software and related software with its subscription. You can use Microsoft Office Apps on Windows, macOS, iOS, Android, and Windows 10 Mobile. If you are short on space, you can use OneDrive which gives you cloud storage. There are many more things using Office 365.

Microsoft Office 365 Error Code 30180-4

Office 365 is available for personal use and business purposes. Its design and performance have changed a lot over the years and become advanced. But sometimes a user may have problems while using Office 365. One of these errors is the Microsoft Office 365 Error Code 30180-4 which occurs when installing Office on your device.

How to Avoid MS Office 365 30180-4 error code?

  • Try to install Office 365 using the offline installer.
  • Use a wired connection to access the Internet instead of a wireless connection.
  • Install Office from another location, your network may be restricted so that it does not allow Office installation.
  • Make sure that your network provider does not limit data usage or Internet speed.

Fix MS Office 365 ERROR CODE 30180-4

Method 1: Turn off the antivirus temporarily

It is possible that your antivirus is interfering with the installation process by not running certain files on your device. You can turn off the antivirus service to install Office 365 and turn it back on after the installation is complete.

You can also try to uninstall antivirus software to install Office 365. Remember to reinstall it. Contact your antivirus company for the process of disabling and activating your antivirus.

Method 2: Temporarily disable proxy settings

Disable your browser’s proxy settings before installing Office 365 on the device.

  • Microsoft edge
  • Click the Start button in the lower-left corner of your Windows device.
  • Go to Settings and choose Network and Internet.
  • Scroll to the bottom of the screen and select Proxy.
  • In a manual proxy configuration, drag the bar to close it and save the settings.
  • If it is already disabled, exit the configuration window.
  • Internet explorer
  • Launch your Internet Explorer software and click on Tools in the upper right corner.
  • Choose the Internet option and click on the Connection tab.
  • Click the LAN Settings button.
  • Under Proxy Server, turn off the option to “Use a proxy server for your local network (these settings will not apply to dial-up or VPN connections).”
  • Click Apply or OK to save the settings.

If you are using a different browser, go to their help and check how to disable their proxy settings. If this method does not work for you, see the next one.

Method 3: Turn off the firewall temporarily

Disabling your computer’s firewall will put your device in danger. As soon as you finish installing Office 365, be sure to turn on the firewall.

  • For Windows 8.1 and 7
  • Click on the Start button and choose Control Panel.
  • In the search box, type firewall and click Windows Firewall.
  • Go to the left panel and select Windows Firewall on and off.
  • If prompted, allow the administrator and enter the device password.
  • Click Close Windows Firewall, then click OK.
  • For Windows 10
  • Click on the Start button and navigate to the Windows Defender Security System.
  • Then choose the option Firewall and Network Security.
  • Select the network profile under Windows Firewall and disable it.

If you still receive Office 365 error code 30180-4 during installation, contact the customer support team. Be sure to activate all the security systems mentioned above, otherwise, your device will be available for various threats.

Wednesday, December 16, 2020

How to Fix Microsoft Office Error Code 1706

 Microsoft Office application is now an important part of our daily life as it relates to our studies, work, business, and more. And since it is an era of development, Microsoft has launched well-developed and secure products like Office 365 and Office 2016, such as Office 365 and Office 2016. You can buy Office products. List from Microsoft Product Store or. And in some cases, Office installation or update may be completed with microsoft office error code 1706

Microsoft Office Error Code 1706

Step 1. Temporarily disable firewall and antivirus

Error code 1706 may occur when installing or updating Microsoft Office due to network or firewall restrictions. Network rules or network/computer firewall rules can block the installation of an office program or its update as part of their security measures. These firewalls and antivirus rules are applied by the network provider or computer user to the computer on its main system or registry.

You can fix error code 1706 by temporarily shutting down the firewall or antivirus, or you can fix error code 1706 by creating an extraordinary rule to install or update Microsoft Office.

Follow the steps to disable the firewall:

Step 1. Open “Control Panel”

Step 2. Go to “System and Security” then “Windows Firewall”

Step 3. Click “Activate or deactivate Windows Firewall”

Step 4. Select Disable Firewall for private and public networks.

Step 5. Try to install or update Microsoft Office and see if the error code 1706 is fixed.

To disable the antivirus, follow the steps:

Step 1. Open the antivirus application installed on the computer.

Step 2. Click Settings and go to real-time security.

Step 3. Turn off real-time protection.

Step 4. Go to an anti-virus firewall.

Step 5. Disable the antivirus firewall.

Step 6. When prompted click on the YES or OK confirmation prompt.

Step 7. Try to install or update Microsoft Office and check if the error code 1706 is correct.

Step 2. Scan SFC to Fix Error Code 1706

Error code 1706 also occurs with system file errors or corruption. If the error code 1706 occurred due to system file corruption, it can easily be corrected by an SFC scan. SFC scan or system file verification is the process of replacing or repairing a corrupt copy of system files using a cached copy of the file from the scan directory.

Follow the steps to start an SFC scan:

Step 1. Open the command prompt under Administrative privileges.

Step 2. Type “sfc / scannow” and click enter.

Step 3. The analysis will start automatically.

Step 4. Do not close the command prompt until the scan is complete.

Step 5. Try to install or update Microsoft Office and see if the error code 1706 is fixed.

Step 3. Repair the Registry to Fix Error Code 1706

Error code 1706 is also caused by registry code or key-value errors. Corruption or alteration of unique key values ​​can spoil the entire Microsoft Office program.

To fix error code 1706, it is necessary to repair registry keys and rebuild string values. And we ask you to back up the registry before starting the registry repair as the registry is a very sensitive part of the computer system and it is recommended to do so in the presence of an online or offline technician.

Follow the steps to repair the registry:

Step 1. Open Registry Editor

Step 2. Remove the preinstalled or old registry key that is preventing the installation of the latest version or update.

Step 3. Navigate down the keys and remove them.

HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ 11.0

HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ 12.0

HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ 14.0

HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ 15.0

HKEY_CURRENT_USER \ Software \ Wow6432Node \ Microsoft \ Office \ 11.0

HKEY_CURRENT_USER \ Software \ Wow6432Node \ Microsoft \ Office \ 12.0

HKEY_CURRENT_USER \ Software \ Wow6432Node \ Microsoft \ Office \ 14.0

HKEY_CURRENT_USER \ Software \ Wow6432Node \ Microsoft \ Office \ 15.0

Step 5. Also, change the DWORD value in the keys below 0 to 1 in the Office Common Registry folder.

LicenseServers

LicenseServerRedirection

AutoExpandDLsEnable

PassportAuthProvider

Solution 4. Remove and Reinstall.

If the error code 1706 in the registry code, SFC scan and firewall/antivirus exception is not fixed, it is necessary to completely remove the Office suite of programs and features and then reinstall the product for proper use.

Follow the steps below to completely fix error code 1706.

Step 1. Open Control Panel

Step 2. Click on Uninstall Programs and Features

Step 3. Find Microsoft Office in the list.

Step 4. Select Microsoft Office and click Uninstall.

Step 5. After the uninstallation, try running Office Setup to install Microsoft Office.

How to Install Microsoft Office

Step 1. Open My Account

Step 2. Log into the office account using your saved email ID and password.

Step 3. Click the option installed under Office Products in your account.

Step 4. Save the installer configuration if prompted and run it when the download is complete.

Step 5. Do not log out and restart the computer after the installation starts.

Step 6. After the program is fully installed, click the Finish button.

 

Adobe software list: Which apps do you need? Part 1

  The Adobe software list is long, as the Creative Cloud suite covers pretty much every creative need. Whether you're a graphic designer...

Most View