-2
votes
1answer
32 views

sum the values in a column and add the sum to the filename of a workbook

Hello I have been able to create new worksheets based on unique values in a column. In addition to this, i want to sum up the values in a column and include this sum in the filename of each ...
0
votes
0answers
14 views

Excel workbook contains a userform which opens up black on 8.1 office 2010

The userform within the worksheet opens black on windows 8.1 office 2010, yet it opens fine on XP with office 2010. It's a excel 79 to 2003 xls file. We checked trust centre on 8.1 but no joy, ...
0
votes
0answers
30 views

Certain file types (INDD and XLS) routinely corrupt on our Windows Server share

We have recently moved to a Windows Server 2012 R2 (I think) network share, which our office of ~30 people access via Windows machines on a domain. Routinely, but sporadically, InDesign INDD and ...
0
votes
1answer
191 views

Disable custom view in Excel

I am using a shared excel workbook that everytime a user accesses it and saves it, it saves a Custom View for them. I want to disable this settings so that every one can see only same view of the ...
0
votes
1answer
61 views

MS Office Word - EXCEL

I've got a problem: I want to create one document, consisting of different documents. Using an excel sheet (comparable to mail merge therefore) ! But: Every recipient has a different content. ...
-1
votes
1answer
60 views

Change values on x and y axis on a graph

I want to change the values on a graph, but I don't have the initial data, means I have just the graph. Any idea?
-2
votes
1answer
61 views

Automatically go to next row when certain number of characters is entered

I am creating an Excel sheet where there is a comments section where the column width is 58 characters. Is it possible for someone putting in comments to have it automatically go to the next row ...
0
votes
1answer
204 views

How to get the difference between two dates based on an item (truck) number

I'm trying to set up a database for a co-worker to track information based on truck number, amount disposed, etc. Sometimes trucks are left with garbage at then end of the day. That truck may not be ...
1
vote
1answer
4k views

Run macro upon opening Excel 2007

I need help setting up macro that runs each time I load Excel 2007. I have tried following a few walkthroughs on the web but they end up not autolaunching the macro.
13
votes
5answers
63k views

Need two excel windows side by side, on different monitors, in the same instance

I have to do work between two spreadsheets and I need to view them side by side. I can't just open the workbooks in separate instances because I need to make use of features like paste formatting, and ...
0
votes
1answer
2k views

How do I avoid saving Excel files in the temp directory in Windows XP?

How do I make sure that I don't save files (Excel in this case) in C:\Documents and Settings\u.sername\Local Settings\Temp? (Apart from having my brain in gear!) It's kind of disconcerting to save a ...
19
votes
15answers
42k views

How to make cells perfect squares in Excel?

In Microsoft Excel, I want to make the height of first three rows and first four columns (12 cells in the top left corner) such that these cells are squares. How can this be done? Surprisingly, ...
8
votes
3answers
27k views

What the heck have I done to my Excel sheet (and how to undo it)?

I have a lot of Excel sheets for all sorts of things - but none has ever acted up like this one here: This used to be a totally normal Excel 2007 sheet which I was able to resize, maximize etc. - ...
6
votes
2answers
1k views

Two large, linked Excel files take 30 minutes to save, except in VMWare environment

I support some tax consultants who love to use Excel when they should probably be using Access. Anyway, they have created two Excel files, A and B. File B has cells linked to file A. File A is 27 ...
1
vote
3answers
126 views

Excel 2007 shortcut?

Is there a shortcut in Excel 2007 (or a simple way to define one) to paste all copied values, but without formatting ? I'm entering some data in tables, and it would really save my life, that one.
7
votes
3answers
1k views

Splitting Excel 2007 in task bar

I wish to view 2 Excel 2007 files in 2 different Excel windows, although there are 2 "Excels" in the task bar, they both points to the same app. how can I make it split (like word)?