-
as seen on Super User
- Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error,
"This workbook contains Excel 4.0
macros or Excel 5.0 modules. If you
would like to…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format.
I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed.
For this web project I'm building, the server doesn't have office installed…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Any ideas why this code will not work?
Workbooks.Open Filename:="C:\a.xls"
Workbooks("a.xls").Activate
Worksheets("b").Select
Dim OutputArray(10, 10)
OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value
I'm trying to run a macro in one file (unnamed…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Given the following workbook events:
BeforeClose
BeforeSave
Please tell me:
- The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving.
- What happen if user cancels one of the saving…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have to SQL Server views being drawn to 2 seperate worksheets as pivot tables in an excel 2007 file.
the results on worksheet1 include example data:
- company_name, tickets, month, year
company1, 3, 1,2009
company2, 4, 1,2009
company3, 5, 1,2009
company3, 2, 2,2009
results from worksheet2…
>>> More
-
as seen on How to geek
- Search for 'How to geek'
PivotTables are one of the most powerful features of Microsoft Excel. They allow large amounts of data to be analyzed and summarized in just a few mouse clicks. In this article, we explore PivotTables, understand what they are, and learn how to create and customize them.
Note: This article…
>>> More
-
as seen on Super User
- Search for 'Super User'
Often I am creating pivot tables that summarize some count by some category. Let's say I am counting Yes/No responses by some category. I usually add the count field and display it as a "% of row", and then create a pivot chart. However, if I want to sort one of the columns, say "Yes", Excel sorts…
>>> More
-
as seen on Super User
- Search for 'Super User'
Question1: What is the best online forum to ask MSFT Excel questions of the following variety?
Question2: How can I link an excel pivot-table to a potentially changing source table without having to re-draw the excel pivot-table layout every time the source table changes data. (Note, the columns…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi!
I need to create a pivot like this
BatchID-1 BatchID-2
BachName-1 BachName-2
Chemical-1 0.1 null
Chemical-2 null 0.3
Here i need to display the value of specific chemical if Specific BatchID and BatchName
Can…
>>> More
