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

August 26, 2014

Microsoft.Jet.OLEDB.4.0 provider is not registered

Error:
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.

Resolution:
There is no chance to use of Microsoft.Jet.OLEDB.4.0 and Microsoft Access Files like mdb file on 64bit Windows

Solution 1:
Right Click on Project > Properties > Build > Change Platform Target to x86 and recompile it again

Solution 2:
Go to App.config and change ConnectionString from Provider=Microsoft.Jet.OLEDB.4.0 to Provider=Microsoft.ACE.OLEDB.12.0

March 24, 2014

Edit Google Document with Microsoft Word

Questions:
- How to edit google document with microsoft word
- How to open a MS Word Document from Google DOCS, edit it, and then save it directly back to Google Document
- How to change a document in Google Drive
- Editing and Working with Microsoft Office on Google Documents

Solution:
Add new REVISION by right click on your document in Google Drive and select Manage revisions... and select Upload new revision and upload your new version of document

March 20, 2011

How to fix a row in Excel

How do you fix a row in Excel?
How do you freeze a row in Excel?
How do you fix a column in Excel?
How to fix a row in Excel when you move that one stays fixed?
How fixed column/row in Microsoft Office Excel?

Solution
1- Select Row/Column
2- Select View in ribbon

3- Select Freeze Panes from Window Section
4- Enjoy :-D

September 24, 2007

How to fix a cell in excel

- Fix a cell in excel
- How do i fix a cell in excel


The secret of excel for fix a cell is $ symbol …
For example, if you want to fix the A1 in formula =B1*A1 then change formula to =B1*A$1.
The $ symbol in a formula tells excel not to use this cell for copy command.