12 Eylül 2014 Cuma

How to set default zoom in excel 2013

Hi all,

I googled it but I haven't found a satisfactory answer. After that, I realised that you can save your template as .xltx format to the your Custom Office Template folder, C:\Users\yourUser\Documents\Custom Office Templates .
It is so simple,

  1. Open a new excel document 
  2. Create your template (I changed zoom to %85)
  3. Then Save As your document with the name you give. (I gave it as Minus Fifteen Zoom :))
  4. When opening a new excel document you see yout template that you save in Personal section. 
  5. Open it and enjoy your template. 


Have a nice excels...

11 Eylül 2014 Perşembe

OPENDATASOURCE usage

If you like to reach a server which is not defined for Linked Servers where you are working, and if you know  a user which has access for that server then you can OPENDATASOURCE as follows;

select * from  OPENDATASOURCE('SQLOLEDB','Data Source=ServerYouWantToReach;User ID=userNameForThatServer;Password=passwordForThatServer').databaseName.SchemaName.TableName

You can use this for inner join etc.

Have a good use.

For: More info: http://msdn.microsoft.com/en-us/library/ms179856.aspx