Also ran into that. It seem, after running the [Document Inspector][1] in Excel, it will show you this warning whenever you save your file. 
Go to `File &gt; Info` and click in `&quot;Allow this information to be saved in your file&quot;`. The next time you save there should be no more warning.

![enter image description here][2]

  [1]: http://office.microsoft.com/en-001/excel-help/remove-hidden-data-and-personal-information-from-office-documents-HA010037593.aspx#BM3
  [2]: http://i.stack.imgur.com/9usO0.png

I fix it with this way :

According to [This][1] biography , It says :

I had the same problem, it&#39;s incredibly annoying and there&#39;s strangely little posted about it on the interwebs. Anyway, here&#39;s how you fix it:

 - Goto File in the upper left hand corner
 - Options &gt; Trust Center &gt; Trust Center Settings &gt; Privacy Options &gt; 
 - Un-check the check box that says &quot;Remove personal information from file properties on save&quot;
 - Hit OK.

![enter image description here][2]


  [1]: http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/be-careful-parts-of-your-document-may-include/fae98705-d078-4fc5-843a-908dda5be559
  [2]: http://i.stack.imgur.com/JYYoX.png
  [3]: http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/be-careful-parts-of-your-document-may-include/fae98705-d078-4fc5-843a-908dda5be559

I have a dataframe like this:

    In[1]: df
    Out[1]:
          A      B       C            D
    1   blue    red    square        NaN
    2  orange  yellow  circle        NaN
    3  black   grey    circle        NaN
and I want to update column D when it meets 3 conditions. Ex:

    df.ix[ np.logical_and(df.A==&#39;blue&#39;, df.B==&#39;red&#39;, df.C==&#39;square&#39;), [&#39;D&#39;] ] = &#39;succeed&#39;

It works for the first two conditions, but it doesn&#39;t work for the third, thus:

    df.ix[ np.logical_and(df.A==&#39;blue&#39;, df.B==&#39;red&#39;, df.C==&#39;triangle&#39;), [&#39;D&#39;] ] = &#39;succeed&#39;
has exactly the same result:

    In[1]: df
    Out[1]:
          A      B       C            D
    1   blue    red    square        succeed
    2  orange  yellow  circle        NaN
    3  black   grey    circle        NaN



pandas : update value if condition in 3 columns are met

Does anybody know what is the limit for the number of values one can have in a list of expressions (to test for a match) for the IN clause?

&quot;IN&quot; clause limitation in Sql Server

I use `Excel 2013` and `Power View` and `SQL Server 2008 R2`.

After create my `Data Source` and my `chart` in `Excel` When I want save my Excel file I get this message

    be careful parts of your document may include personal information 
    that cannot be removed by the Document Inspector.

What is this warning and how I can remove this message?
What are `personal information` that exist in my `Excel File`.

![enter image description here][1]


  [1]: http://i.stack.imgur.com/B7NS7.png

be careful parts of your document may include personal information that cannot be removed by the Document Inspector

I use <code>Excel 2013</code> and <code>Power View</code> and <code>SQL Server 2008 R2</code>.
After create my <code>Data Source</code> and my <code>chart</code> in <code>Excel</code> When I want save my Excel file I get this message
<pre><code class="hljs language-csharp">be careful parts of your document may include personal information 
that cannot be removed by the Document Inspector.
</code></pre>
What is this warning and how I can remove this message?
What are <code>personal information</code> that exist in my <code>Excel File</code>.
<img src="http://i.stack.imgur.com/B7NS7.png" alt="enter image description here">

I have a table where I am storing timespan data. the table has a schema similar to:

    ID INT NOT NULL IDENTITY(1,1)   
    RecordID INT NOT NULL  
    StartDate DATE NOT NULL  
    EndDate DATE NULL  

And I am trying to work out the start and end dates for each record id, so the minimum StartDate and maximum EndDate. StartDate is not nullable so I don&#39;t need to worry about this but I need the MAX(EndDate) to signify that this is currently a running timespan.

It is important that I maintain the NULL value of the EndDate and treat this as the maximum value.

The most simple attempt (below) doesn&#39;t work highlighting the problem that MIN and MAX will ignore NULLS (source: http://technet.microsoft.com/en-us/library/ms179916.aspx).

    SELECT recordid, MIN(startdate), MAX(enddate) FROM tmp GROUP BY recordid

I have created an SQL Fiddle with the basic setup done.

http://sqlfiddle.com/#!3/b0a75

How can I bend SQL Server 2008 to my will to produce the following result from the data given in the SQLFiddle?

    RecordId  Start       End  
    1         2009-06-19  NULL
    2         2012-05-06  NULL
    3         2013-01-25  NULL
    4         2004-05-06  2009-12-01


How can I include null values in a MIN or MAX?

I have a schema in SQL Server 2012.

Is there a command that I can run in SQL to get the names of all the tables in that schema that were populated by user?

I know a similar query for MySQL `SHOW TABLES;` but this does not work with SQL Server.

List names of all tables in a SQL Server 2012 schema

I can&#39;t start the `SQL Server browser` from `SQL Service Configuration Manager 2008` version. There are absolutely no options to start the service. It&#39;s disabled as image shown below. How should I start the service again?

![window][1]


  [1]: http://i.stack.imgur.com/8FNXN.png

I cannot start SQL Server browser

    SELECT REPLACE(&#39;&lt;strong&gt;100&lt;/strong&gt;&lt;b&gt;.00 GB&#39;, &#39;%^(^-?\d*\.{0,1}\d+$)%&#39;, &#39;&#39;);


I want to replace any markup between two parts of the number with above regex, but it does not seem to work. I&#39;m not sure if it is regex syntax that&#39;s wrong because I tried simpler one such as `&#39;%[^0-9]%&#39;` just to test but it didn&#39;t work either. Does anyone know how can I achieve this?

Regex pattern inside SQL Replace function?

I have two numbers as input from the user, like for example  `1000` and `1050`.

How do I generate the numbers between these two numbers, using a sql query, in seperate rows? I want this:

     1000
     1001
     1002
     1003
     .
     .
     1050


How to generate a range of numbers between two numbers?

It seem simple but I cannot find a way to define a range that goes up to the end of the column in an Excel formula.

For instance I can use this equation SUM(C:C) to sum all number found on the column C. However, given that the top of the page has titles and column headers, I would like to start my range at line 6. I thought SUM(C6:C) would do it but it does not work in Excel.

This is required so my SUM is always right no matter how many lines of data I add to my document in the future.

Thanks.

Sum up a column from a specific row down

I am working on angular js app and I stuck in a situation in which I have to export data to Xls using angular js. I have searched a lot on the internet for export functionality or any library for angular js so I can do that or at least I can get the idea how to export. I don&#39;t have any code or work to show here. 

 I need suggestions. Please help me on this. 

Thanks in advance.

Update:

I have a data which is an array of objects and I am iterating that on UI in a table. My backend is node.js and frontend are angular js.

My problem is if we have the data from the server and I am using on UI, how can I use the same data to export to Xls using angular js. I don&#39;t want to give a call again on the backend to extract the data and export that. 

In the existing table, the user can select the checkbox (Any number of rows or all rows) to extract the data to Xls.

In node.js I have used node module whose name is: Excel and it is available on nodemodules site.

My data is like that:

    &quot;data&quot;: [
        {
    		&quot;Name&quot;: &quot;ANC101&quot;,
    		&quot;Date&quot;: &quot;10/02/2014&quot;,
    		&quot;Terms&quot;: [&quot;samsung&quot;, &quot;nokia&quot;: &quot;apple&quot;]
    	},{
    		&quot;Name&quot;: &quot;ABC102&quot;,
    		&quot;Date&quot;: &quot;10/02/2014&quot;,
    		&quot;Terms&quot;: [&quot;motrolla&quot;, &quot;nokia&quot;: &quot;iPhone&quot;]
    	}
    ]

I want the solution using angularjs or any angularjs library.

Export to xls using angularjs

I am new to [epplus][1], and i&#39;m trying to read some values from an excel table.

This is what I have so far:

    var fileInfo = new FileInfo(filename);
    using(var excelPackage = new OfficeOpenXml.ExcelPackage(fileInfo))
    {
        foreach (var sheet in excelPackage.Workbook.Worksheets)
        {
            foreach (ExcelTable table in sheet.Tables)
            {
                 foreach(var row in table.Rows)  // &lt;-- !!
                 { ... }
            }
        }
    }


However, now I am stumped, as the `ExcelTable` only has a `Columns` property, but not a `Rows` property as I had expected. I cannot find a `Rows` property on any object in the library.

**How do I iterate through a table, reading Row for Row?**


  [1]: https://epplus.codeplex.com/

How do I iterate through rows in an excel table using epplus?

This bothers me for my whole IT life - I worked with 7 different versions of Excel over 20 years now, with big changes in each version, forcing me to search where the old features are hidden in the new version - but one single thing stays solid as a rock: the disability to open two files with the same name.

&gt; Sorry, Excel can&#39;t open two workbooks with the same name at the same time.

So I&#39;m really longing for an insight here, why this is still the case in Excel 2013, which was not even necessary to implement in Excel 95? Is there any technical or design reason within the Excel data structures or internal processings that it can&#39;t handle two File objects with diffenrent paths but the same file name? I don&#39;t want no Microsoft bashing here, I just want to understand the reason behind it.


Why on earth can&#39;t Excel handle 2 files with the same name?

I have a sub that calls on **ActiveWorkbook.RefreshAll** to bring new data in from an XML source, and then performs multiple modifications to it. The problem is that not enough time is given for the RefreshAll command to finish, so the following subs and functions end up not executing correctly, which result in repeated rows not being correctly erased.

I have tried using **Application.Wait** and the **Sleep** function, but they seem to pause the refresh process too. I simply want the rest of the code to wait until the refresh process finishes before executing the rest of the code.

Any ideas on how to implement this? Right now I was only able to fix it by not calling on RefreshAll, which gives me the idea of implementing a second flow to be executed afterwards, but that&#39;s not a good workaround.

Please let me know if any of this wasn&#39;t clear. Thanks

**EDIT**
So I tried a few suggestions from the posts below, and this is what I was able to come up with.
Doing a &quot;record macro&quot; and then UNCHECKING the &quot;Enable background refresh&quot; in the table properties did not result in anything. I did a refresh as well afterwards. This was the result of the recorded macro:

    With ActiveWorkbook.Connections(&quot;XMLTable&quot;)
            .Name = &quot;XMLTable&quot;
            .Description = &quot;&quot;
    End With
    ActiveWorkbook.Connections(&quot;XMLTable&quot;).refresh

The class **ActiveWorkbook.Connections** does NOT have a **BackgroundQuery** option so that I can set it to False. Any ideas?

Just to be clear. This is an XML file hosted on a website which Excel goes and imports into a table. I then call that data into a pivot and other things. The goal here is to allow the import process from the website to the table to finish BEFORE executing any other commands.
Thanks

**EDIT2:**
After a little more research, I have found this page: [http://www.mrexcel.com/forum/excel-questions/564959-execute-code-after-data-connection-refresh-finished.html][1]
It appears that an XML type of connection does not have a **BackgroundQuery** boolean. That option is only available for ODBC and OLEDB connections, which are types xlConnectionTypeODBC and xlConnectionTypeOLEDB, respectively. The XML connection I am using is of type xlConnectionTypeXMLMAP which does not have a **BackgroundQuery** option.
Does anyone have any idea on where to go from here? The only solution I have in mind right now is to make two seperate macro buttons on the excel sheet, one for refreshing and one for data modification, but I&#39;d rather keep that option to the very last.


  [1]: http://www.mrexcel.com/forum/excel-questions/564959-execute-code-after-data-connection-refresh-finished.html

Wait until ActiveWorkbook.RefreshAll finishes - VBA

What is the difference between PowerPivot, PowerQuery and PowerBI? How should one decided which tool should be used and when.

Content Type	Original Author	Original Content on Stackoverflow
Question	Ardalan Shahgholi	View Question on Stackoverflow
Solution 1 - Sql Server	n1000	View Answer on Stackoverflow
Solution 2 - Sql Server	Ardalan Shahgholi	View Answer on Stackoverflow

be careful parts of your document may include personal information that cannot be removed by the Document Inspector

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

"IN" clause limitation in Sql Server

pandas : update value if condition in 3 columns are met

Attributions