Saturday, September 1, 2018

Recover Deleted Files in Microsoft Windows 10

While cleaning up the desktop, you may delete your important files from the system. The situation could worsen when you are not able to recover even from Recycle Bin. Well, the data is not deleted entirely from the device. It is still available on the hard drive. It is very pleasant to know that data the recoverable as it is in the hard drive, but how to recover these lost files? Don’t fret about it as there are ways to recover the deleted files in Windows 10.

Follow the steps carefully to recover the lost data in your computer

  1.    Windows 10 has an inbuilt freeware which helps to restore
  •    Open the folder containing Deleted Files
  •    Click History and select Previous
  •    Choose the files and click Restore
  1.    Create the file with the same names
  •    You need to create a file with an identical name of the deleted files
  •    Right-click in the desired folder and click Properties
  •    Select Previous Version
  •    Click the right file version to restore. You need to remember the exact name of the previous file
  •    It will work only for document restoration only
  1.    Third party tools to recover the data
  •    If the two methods didn’t work, you can download a third party tool to recover the lost data. These are safe and work efficiently without interfering in the system settings, privacy and security
  •    RecuvaWise data recoveryFree Undelete, etc. are the examples of third-party tools to recover the data
  •    To restore the lost data, download Recuva Portable version. Remember to download it another computer because it can overwrite the deleted file from hardware resulting in complications to restore the file
  •    Move the tool to the external drive like USB flash drive. Extract the drive first.
  •    Now connect the drive to the computer with deleted files
  •    Open the tool from the external drive
  •    Follow the instruction in the tool and click to begin the process
  •    Select the deleted file type or else select All Files
  •    Click “Next” and the tool will ask you to choose the location from where the files were deleted
  •    If you remember the folder, then click the given option or else select “I’m not sure”
  •    Click Next
  •    Now click Enable Deep Scan and Start to begin the process
  •    It will take long hours to complete the process
  •    The tool will show the files with circles indicating whether they can be recovered or not.
  •    Green Circle means the file is recoverable
  •    Red Circle means the file is overwritten and may not recover
  •    Orange color means that the file can be recovered even though the data is overwritten
  •    Select those files desiring recover and click Recover to get your files back in the system
With the help of Recuva, the deleted files will be recovered but it is always good to have a backup of your data in your system, or you can use Windows built-in backup solutions. It will save time and effort, and you get your files restored.
Mir Ariif is a Microsoft Office expert and has been working in the technical industry since 2002. As a technical expert, Samuel has written technical blogs, manuals, white papers, and reviews for many websites such as office.com/setup.

Friday, August 31, 2018

Microsoft announced new features in OneDrive and SharePoint

Microsoft has declared about their plan to come out with a series of AI services for the Microsoft Office 365 users who are using OneDrive and SharePoint. Thereafter, the users will be able to enjoy the automated transcriptions from all the audio and video files in OneDrive and SharePoint.
new-features-in-OneDrive-and-SharePoint
Every video and audio file doesn’t need to be transcribed and the functionality made the content inside of theses medium visible and easy to locate them. Microsoft did the survey about the same speech-to-text transcription services, earlier this year and later in July; they have introduced it for the live events and meetings that take place with the Microsoft Teams, Yammer, and Stream.
In OneDrive and SharePoint, the transcripts will be displayed automatically beside the files after the review. In case the video gets shared with the colleagues or friends through Stream, the facial recognition will be then used to differentiate between the participants in the video or video meeting.
The new feature brought for you the ability to share the content with the people who are in the meeting and sharing the content can help them utilizes those in the meeting. Soon the computer vision for Office setup OneDrive or SharePoint file searches will be introduced.
The search file result will contain the text or object identified for the images as well as the capability to look for the images that are based on the photo that has been taken. Based on the audio or the video file recorded in the conversation, you will be able to locate and search for the files through the transcript services.
Later this year, based on the profile in the Microsoft Graph the new files in OneDrive and the Office.com will be viewed recommending on the documents and other forms of the content. The suggested files depend on the intelligence of the Microsoft Graph content, how it works and the activity of the content gets shared among the Office 365.
For downloading the OneDrive and SharePoint, visit Office.com/setup.

Thursday, August 30, 2018

Best Smart Features Of Microsoft Sharepoint 2016

Microsoft SharePoint is regarded as one of the many products of Office productivity suite and is often known as ‘Swiss army knife’ for the combination of the software suits. It can be easily used for accessing the data and the storage, sharing, and managing the documents with the help of the password-protected facility.
new-features-microsoft-sharePoint-2016
Microsoft SharePoint 2016 was released to boost up the hybrid infrastructure as well as take the benefits of the cloud technology. It has been proved to have raised the bar in the productivity, efficiency, and the general organization for the global business purposes.
Here, this article learn about the top 3 smart features of MS-SharePoint 2016 (to download it by visit www.office.com/setup)
Given below are the lists of 3 smart features of MS-SharePoint 2016-

Apply the SharePoint Search

It allows the user to enter and look for the search query against the index data in the SharePoint Server Farm. The main purpose of the search is to have a glance at the current site as well as any sub-sites below it.
The search results contain the links to the documents, libraries, list items, lists and the sites. And the search engine considers the permissions, context, and the previous search result.  Most of the SharePoint web-pages has a search query box exhibits in the top-right side of the page.

Apply the SharePoint Lists

The office product has libraries as well as lists, the two primary ways to manage the information. And the lists are like the Spreadsheets that contain rows and the columns, unlike MS-Excel spreadsheets which are available in SharePoint.
MS-Excel spreadsheets can be shared among many people lately, just to avoid the trouble in emailing the spreadsheet and wait for the review or trying to change the track for the multiple users.
It comes up with the web-based features and ability to create, review, update and delete a list or the items on the list. To commence with the proceedings just click on the ‘Add’ lists >’ Add’ libraries and other apps pane in the get started page.

Apply SharePoint Libraries

It actually allows the user to enjoy a bundle of features like simple ways of storing, enhancing, group, filter, and store the important data or ‘meta-data’ regarding the content saved in the given library, improving the search and the research.
SharePoint library helps the team members to create, collect, update, and manage the files. The default library apps can be used to create the new libraries, depending on the version, set up, and permissions.
In order to create a SharePoint library, all you need to start from the respective site by clicking on the ‘Add lists, libraries, or other apps’ pane.
For activating any of the Office products, you need to visit office.com/setup.

Wednesday, August 29, 2018

How to secure your MS-Excel file with a strong password?

Securing your MS-Excel file with a strong password is not the only step to protect it from getting exploited, they are many ways or layers to protect it but this is just the first step. A strong password should contain the unique password which is hard to guess or break because a weak password is an easy task for them to break.
But there is a slight difference between protecting as well as securing. Protecting means it limits the users’ accessing powers, who manage to come inside, some of the other way. And securing means restrict the users’ from getting inside and saving any changes.
Here, this article learns about why it is important to secure your Office setup Excel with a password and how to do so.
Follow the steps as listed below to put a password to your MS-Excel file-
  • With Save As function to secure the Excel file

  1. Open the particular file, you want to secure with a password.
  2. Depending on the version of Microsoft Excel-
  • For MS-Excel 2007 – Select the ‘Office button’ and click on the ‘Save As’ option.
  • For MS-Excel 2010 – Select the ‘File’ tab and click on the ‘Save as’ option.
  1. Choose the ‘tools’ option from the toolbar and click on the ‘Save’ option.
  • In Microsoft Excel 2007 and 2010 – Select the ‘Tools’ option from the left side of the dialog box.
  1. In the display dialog box, you can set two passwords:
    1. To open the file
    2. Make a modification into the file.
Note- The advanced option will allow you to set the encryption option for the security purpose.
To download the Microsoft Excel for enjoying this feature, you need to visit office.com/setup.
  1. In the ‘Password to open’ box, enter your choose password and click on the ‘Ok’ option.
  2. Re-Confirm the password.
  3. Choose the ‘OK’ option to shut the above dialog boxes, to return to the ‘Save as’ option.
  4. Select the ‘Save’ option to save the Excel file with its password.
  5. Congratulation! Your MS-Excel file is now secure with the password.
  • With Info command function to secure the MS-Excel file

  1.  Open the Microsoft Excel file that you wish to put the password.
  2. In MS-Excel 2010 or 2013- Select the ‘File’ > ‘Info’ > ‘Protect the file’ > ‘Encrypt with password’ option.
In MS-Excel 2007- Click on the ‘Office button’ > ‘Prepare’ > ‘Encrypt Document’.
  1. Enter the password into the ‘Password’ box, after an ‘Encrypt document’ box pops-out.
  2. Click on the ‘Ok’ option.
  3. Re-confirm the password in the ‘Confirm password’ box.
  4. Select the ‘Ok’ option to close the dialog box and save the file.
  5. Congratulation! Your Excel file is all set up with the password.

Tuesday, August 28, 2018

Office 365 July 2018 Feature Update for iOS

There is no gainsaying that Office 365 has gained immense popularly right after its launch in June 2011. To bring in new features and functionalities, Microsoft is releasing timely updates for Office 365 for Windows, Mac, iOS, Android, and web platform.
Office 365
Have a look over the July 2018 Office Setup 365 for iOS update to know what’s new in this productivity suite. Please note that this new update also includes features released in Version 2.15 for iPhone and iPad.
Word Count Displays upon Scrolling
Yes, you read that right! While working on a Word document, you can now see the word count on scrolling. In short, you don’t need to select the complete document (after you finish your work) in order to check out the word count.
Draft Messages Synchronization
The new update has enabled the Office 365 (for which you need to download office setup) iOS users to enjoy synchronization of the draft messages between different Outlook endpoints. This means you can start sending an email on the phone and then finish it anytime on your desktop or vice-versa.
If you want to get these updates, before anyone else, then become an Office insider. To get Office 365, visit office.com/setup and follow the on-screen instructions after creating your Office account.

Monday, August 27, 2018

Microsoft Access Database Engine 2010 Redistributable

This download will install a set of components that can be used to facilitate transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications.
Details :
This download will install a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access 2010 (*.mdb and *.accdb) files and Microsoft Office Excel 2010 (*.xls, *.xlsx, and *.xlsb) files to other data sources such as Microsoft SQL Server. Connectivity to existing text files is also supported. ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.
The Access Database Engine 2010 Redistributable is not intended:
  1. As a general replacement for Jet (If you need a general replacement for Jet you should use SQL Server Express Edition).
  2. As a replacement for the Jet OLEDB Provider in server-side applications.
  3. As a general word processing, spreadsheet or database management system -To be used as a way to create files. (You can use Microsoft Office or Office automation to create the files that Microsoft Office supports.)
  4. To be used by a system service or server-side program where the code will run under a system account, or will deal with multiple users identities concurrently, or is highly reentrant and expects stateless behavior. Examples would include a program that is run from task scheduler when no user is logged in, or a program called from server-side web application such as ASP.NET, or a distributed component running under COM+ services.
System Requirement : –
Supported Operating System
Windows 7, Windows 8, Windows Server 2003 R2 (32-Bit x86), Windows Server 2003 R2 x64 editions, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, Windows Server 2012 R2, Windows Vista Service Pack 1, Windows XP Service Pack 3
Only the 32-bit Access Database Engine may be used on Windows XP Service Pack 3
Install Instruction : –
Note: Before installing this download, you must first remove any previous versions of the Access Database Engine from your computer by using Add/Remove Programs in the Control Panel.
To install this download:
1. Download the file by clicking the Download button and saving the file to your hard disk.
2. Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
3. Follow the instructions on the screen to complete the installation.
To use this download:
1. If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.
2. If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”
If you are connecting to Microsoft Office Excel data, add the appropriate Extended Properties of the OLEDB connection string based on the Excel file type:
File Type (extension) Extended Properties
———————————————————————————————
Excel 97-2003 Workbook (.xls) “Excel 8.0”
Excel 2007-2010 Workbook (.xlsx) “Excel 12.0 Xml”
Excel 2007-2010 Macro-enabled workbook (.xlsm) “Excel 12.0 Macro”
Excel 2007-2010 Non-XML binary workbook (.xlsb) “Excel 12.0”
3. If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
4. If you are an application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”
To remove this download:
To remove the download file itself, delete the file AccessDatabaseEngine.exe
1. On the Start menu, point to Settings and then click Control Panel.
2. Double-click Add/Remove Programs.
3. In the list of currently installed programs, select “Microsoft Access database engine 2010” and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program.
4. Click Yes or OK to confirm that you want to remove the program.
Additional information :-
  1. The Office System Drivers are only supported under certain scenarios, including:
  2. Desktop applications which read from and write to various files formats including Microsoft Office Access, Microsoft Office Excel and text files.
To transfer data between supported file formats and a database repository, such as SQL Server. For example, to transfer data from an Excel workbook into SQL Server using the SQL Server Import and Export Wizard or SQL Server Integration Services (provided the SSIS jobs run in the context of a logged-on user with a valid HKEY_CURRENT_USER registry hive).