1
vote
0answers
190 views

Office 2013 can't open office 2010 protected file,vice versa

I couldn't achieve to produce an interchangeable protected file between Excel 2013 and Excel 2010. Excel 2010 can't open 2013s protected one and 2013 can't open 2010s protected one. I think their ...
0
votes
1answer
64 views

How to copy/paste a Word a file that has a linked formatted text?

I link some datas in a word file in order to have dynamic fields. I do it by this way I add a Text field from Under Developers - Controls - Text. I write something to this text field and copy it ...
0
votes
0answers
52 views

Excel: Timeline for Pivot Table based on XML imported data in Office 2010?

I imported XML data into Excel document on Sheet 1. Added Pivot Table based on that data to Sheet 4. Then I made a chart based on that Pivot Table. Is there any way to create a timeline just like in ...
1
vote
1answer
121 views

Custom formatting numbers in a decimal format

I have a weird problem with custom-formatting MS Excel 2010. I am just trying to make formatting of custom number, for example 110,5 should be shown as 110.5, but there is my problem: #.# or any ...
0
votes
0answers
52 views

Is it possible to set the default printing mode to “print selection” in Excel 2010?

I'm working with some pretty big Excel Files and usually I only print a selections of the lines in these Files. Once or twice a moth i forget to change the printing mode to "print selection" and until ...
0
votes
1answer
405 views

Scatter chart series with uneven data intervals

I have two series of data I wish to plot on the same graph: Series 1 has 10 data points, Series 2 has 15 data points. I want to show both series on the same chart (presumably Scatter) with the points ...
1
vote
1answer
55 views

Re-using conditional formatting in MS Office (Word/Excel)

I very often find myself with a formatting that I want to apply to several specific but isolated parts of a document or worksheet, without disturbing the format of the surrounding areas. The ideal ...
0
votes
2answers
401 views

If / Else logic involving text i Excel

I want to perform the following logic in a Microsoft Excel 2010 worksheet: In cell E3: if C3 = Off or off then VALUE=0, else Value=C3*D3 Where cell C3 will contain either a number or the word 'off' ...
0
votes
1answer
416 views

When launching Excel 2010, multiple unwanted macro windows open

When the user launches Excel 2010, it will open five or six windows of excel macros. I know that this is typically removed by accessing View > Macros > Remove the macro but due to the fact that ...
4
votes
1answer
3k views

Why does Office 2010 fail to open an Excel file?

I have a excel file I've put on a file server. When required i access it via a dll, fill it with some data in background only (through ExecuteExcel functionality). It used to work before. Recently I ...
1
vote
2answers
657 views

MS Excel and Access - which is better for reports?

Where I work, staff have just started to use a basic table in excel (1 October) to record sales which has about 10 columns (name, client, renewed, discount, paid etc). I record the data (total sold ...
4
votes
1answer
351 views

How do I set the default file save location of an Office document to be the same folder as the template's folder?

I have a series of Microsoft Office 2010 templates (Excel, PowerPoint and Word) spread through a pre-defined folder hierarchy. I need to make sure that when a new document is created from one of ...
3
votes
2answers
486 views

Languages of Microsoft Office

I am in France, and I just bought the CD Microsoft Excel 2010. While installing it, there was no option to choose the language. After the installation, the language is in French which matches the ...
11
votes
5answers
26k views

How do I force excel (and other office products) to stop opening files in the same application?

Whenever I "double click" on an Excel file and another Excel file is open, the newly opened file automatically opens in the same application window as the previously opened Excel file. This isn't ...
3
votes
2answers
13k views

How do I bring back the ribbon in Office 2010?

The ribbon in Excel 2010 appears when I click on Home or Insert or one of the other tabs, but disappears again when I go back to editing my document. I'd like it to always be visible - how can I get ...
1
vote
0answers
266 views

Is there anyway to co-author with the Excel 2010 Desktop App?

I'm wondering if there is clean way to co-author with the Excel 2010 desktop App? Now, or possibly this could be a placeholder for the future. The current answer seems to be no with Excel 2010 desktop ...
1
vote
2answers
264 views

Assembling Word Doc using Data from Excel- MS Office 2010

I have a questionnaire that users complete. It is in Excel. After users complete the questionnaire I would like to be able to generate a Word document that contains their answers. For example "The ...
0
votes
1answer
139 views

Pivot Tables in Excel

I have a Pivot Table counting occurrences of a product on a computer. So the rows are the name of a computer. The columns are Adobe products. The last column is a COUNTA, so every machine that has a ...
3
votes
4answers
23k views

How do I change the default paper size to A4 in Excel 2010 (and other Office 2010 programs)?

I've looked in the usual places, page settings, and printer settings, but unless I go to Page Layout and select A4 for each new sheet, it opens as letter. I've found a few workarounds, but they all ...
0
votes
1answer
722 views

How do I design a form in Word that queries and inserts data from an Excel table?

I put together several document submittals per day, and for the coversheet I manually copy/paste from an Excel table into Word for the document list. Also, each coversheet has a header with the ...
1
vote
1answer
310 views

Excel 2010: Home tab is blank

A user on our network has somehow managed to empty out their home tab in Excel. I've not had much luck finding a fix on Google. Does anyone have any ideas how to fix this? The tab cannot be ...
0
votes
1answer
772 views

Office 2010 Trusted Locations not working after restart

In Excel 2010, on Windows XP, I am unable to open files - through the open dialog box - from a network drive. The sever has already been added to the Trusted Locations and now most security settings ...
0
votes
3answers
8k views

I cannot open Excel file

I have office 2010 installed and the file was working but suddenly when I try to open it It gives me following error Excel cannot open the file ... because the file format or the file extension ...