-3
votes
1answer
28 views

Custom Data Validation in Excel 2010

I'm trying to make error messages appear when someone tries to enter the wrong data type in a certain cell with data validation in Excel 2010. Is there a feature or some sort of formula I can use? ...
0
votes
0answers
10 views

Editing registry for the error - One of your object libraries (I) is missing or damaged. Please run setup to install it

When I opened an excel (.XLS) file today, I got an error - One of your object libraries (I) is missing or damaged. Please run setup to install it. I don't know why that happened, but it could be ...
0
votes
2answers
31 views

Excel: Applying Condittional formatting to every other row

I would like to apply a specific conditional format to every second row in my spreadsheet. In my specific case I have regression results, where the first row indicates the beta coefficient and the ...
0
votes
0answers
22 views

Powerpoint 2013 - CPU spike

for some reason when i run PPT and/or Excel 2013, and even despite pretty robust and new system (see below, please correct me if i am wrong), my computer commands of large amounts of memory and CPU, ...
1
vote
2answers
27 views

conditional formatting excel 2013

Is there a way to highlight a cell (possibly with conditional formatting) if one of the cells to the left of it has data, but it is empty? for instance, A B C D ...
1
vote
0answers
39 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 ...
2
votes
1answer
48 views

Excel 2013 table formatting

I currently have a table that looks like this: Company | 2013 Total | 2013 Gross $'s | 2013 Gross % | 2012 Total | etc.. | | | | | ...
0
votes
1answer
35 views

excel - if value grater than, use that value

I am having problems with my excel function. I want to: if value 1 is greater than value 2, then write value 1 in a cell. If value 2 is greater than value 1, then write value 2 in the cell. ...
0
votes
1answer
28 views

How do I prevent Excel from changing the color of a clicked link?

I'm using Excel 2010. And as most Excel users know, if a cell is also a link, once you click it it turns to this awful purple color. For me this ruins the color coding I'm using to show the status ...
3
votes
2answers
60 views

Setting default editor language in word 2007

I want to change my default editing language in word as English (India). It is not so possible to change the language setting in all users and all PCs manually. Manually we can change the default ...
0
votes
1answer
35 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
1answer
39 views

Create excel checkbox and lock other cells in the same row WITHOUT using macros

I'm trying to find out if it's possible to avoid macros to do the following: when the user ticks a checkbox, it locks all other cells from the same row. If he unticks, it unlocks the cells... At this ...
0
votes
0answers
24 views

Force PowerPoint to open a new Excel instance

When using the insert diagram function in PowerPoint, PowerPoint automatically opens a new Excel window. Unfortunately, if you already have an Excel workbook open, it will simply use the same Excel ...
0
votes
1answer
23 views

Set Excel 2010 file format in the registry

If you install MS Office (2010 in my case) and run up any of the programs (Excel in my case) for the first time you encounter the following dialogs: The Username dialog for setting a default user ...
0
votes
0answers
46 views

Can't choose “rows to repeat at the top” in excel page setup menu

I purchased a brother dcp-8150 printer and now when i'm in office 2007 excel file my "rows to repeat at the top" option in page setup cannot be highlighted. Can you help
4
votes
1answer
110 views

Using English macros in French version Excel

I am currently in France and am using a computer on which all Office programs are in French. I need to use a Macro which has been written in English VBA, but it fails. I assume the issue a language ...
0
votes
1answer
350 views

How do I automatically sync/couple an Excel file to Onedrive on Mac OS X?

I know how to save a file on Onedrive and it all works fine. But I would like to couple an Excel-file on my computer (or elsewhere) to Onedrive. That is: I work on a file in Excel and when I save that ...
1
vote
1answer
99 views

How do I get ALT-ENTER wordwrap to auto-fit the height the cell EXCEL?

I am using ALT-ENTER for hard word wrapping in a cell. However, when I use it, the autofit height doesn't work properly. It fits the height of the cell to the first line. Is there any solutions to ...
0
votes
1answer
19 views

Conditional Formatting with Office 2008 for Mac

I'm working with a 2,000 line spreadsheet in which I want to isolate certain lines based upon certain key words in descriptions contained in the 1st column. I have tried using Conditional Formatting ...
1
vote
1answer
19 views

Excel 2010 switching to formula view after every click

Since I installed Excel 2010 64-bit (was using 32-bit version before), every time I click on an icon in one of the ribbons, e.g. reducing icon size: The top bar switches to the formula view: ...
0
votes
1answer
50 views

Generate ordered numeric list in Excel based on cell value

I'm not sure if this is possible, but I would like to create an ordered numeric list automatically based on a cell value. For example, if I have a cell with a value of 100, I want excel to ...
0
votes
0answers
46 views

Export to excel not working if ms office is not present on machine

You might think this can be a possible duplicate to questions like this: How to create excel file witout installing MS Excel in vb.net? However this is not the case, I've googled a lot and things are ...
0
votes
2answers
27 views

Convert folder of word docs into a single, parseable spreadsheet

Is it possible to show MSWord a folder full of .docs or .docxs and have it convert them into a spreadsheet containing columns for different variables that describe each document, such as filename, ...
0
votes
1answer
84 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
2answers
57 views

How to set character per line limit in word or excel or any other program?

I'm doing an application online and part of a section requires 7 lines of writing. However in each line it requires no more than 130 characters. I have done the 7 lines but some lines are over 130 ...
0
votes
0answers
37 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 ...
0
votes
1answer
84 views

Access Database engine Issue

I have recently moved from 32 bit to 64 bit version PC which runs 32 bit version of Office package. I have an application (.net 4.0) which handle excel files and which uses the ...
0
votes
2answers
37 views

Assigning numbers to strings in a column in Excel

I have a spreadsheet in which columns can have values among a set of strings, for example Income column can have values such as: High, Low, Medium, etc. How to know which unique strings there are in ...
0
votes
1answer
16 views

odc connection error via LocaleIdentifier

On the network drive I have an xlsx file with a OLAP Pivot in it. This file uses a connection in a seperate odc file that is saved on the same network drive. Several people have access to both of ...
1
vote
0answers
48 views

Select split rows in Excel and have them print on the same page

I'd like to select several rows in Excel from one sheet, that may not be next to each other and when they are printed using the "Print Selection Only" option, show up on the same page, instead of one ...
0
votes
0answers
221 views

Microsoft Office 2013: buttons/icons/text disappear

A few days ago I opened my Microsoft office programs and discovered that they are missing the editing icons at the top, some of them will appear if you scroll over them, but not all. Also, in ...
1
vote
0answers
433 views

Remove 'file locked for editing' attribute from MS Word/ Excel documents

In the same essence as this question Excel file locked for editing. Is there a command I can type to remove the lock flag? for example: attrib -R example.docx -- The story -- In our office we ...
0
votes
1answer
28 views

Custom Formatting dimensions of a box in Excel

I am currently creating a spreadsheet in Excel and setting a standard for everything I am copying in. Some of the text I am entering is different to the format I want it in. The format I want is for ...
0
votes
1answer
150 views

How do you click and drag lower right corner of a cell (autofill) in excel using the keyboard? [duplicate]

If I press CRTL+Down I move to the cell before the empty cell. If I press CTRL+SHIFT+End I end up selecting everything between the active cell and the next empty cell. Now if I want to auto fill ...
0
votes
1answer
192 views

Generating random tests from a spreadsheet and template in Office 2013

The task I'd like to complete is to keep an item bank in Excel, complete with text for the item, correct answer(s), tags for the item to indicate what it measures and what materials its based on. ...
3
votes
3answers
143 views

Filling empty spaces in a column with a series in Microsoft Excel

I have a list like this: A B Student ID Student Name 20496836 Barnes, Troy 28682693 Bennett, Shirley Edison, Annie 28395839 Hawthorne, Pierce ...
1
vote
1answer
131 views

Displaying Other Values Via COUNTIF in Excel

Basically I have a sheet like this: A B C D Name (From File 1) Name (From File 2) Phone Number Countif Walt ...
2
votes
1answer
2k views

Microsoft Word 2013 - Cannot Paste Special

In Word 2013, I am trying to paste the contents of my clipboard which contains a formatted table from Excel into a word document. When I press ALT+E and then press S to bring up the special paste ...
0
votes
1answer
180 views

Linking to Other Excel Sheets Greyed Out (Excel 2011 Mac)

I just got a file from my colleague which has some broken links. They were broken because the path to the cells pointed directly to a file on her computer. She sent over those files, and now I have to ...
0
votes
1answer
184 views

Trying to Use AppleScript to Convert .xls and .xlsx to .txt (Tab Delimited), Needs Fixing

I copied this from an answer I got from another thread. I am trying to convert ~300 .xls and .xlsx files to tab delimited. They are all in the same folder. If anyone knows a better way, please let me ...
1
vote
1answer
567 views

Excel Mortgage Amortization Schedule w/ large extra principal payment calculation

I have been using a Mortgage Amortization Schedule to figure out my loan payments: http://office.microsoft.com/en-us/templates/mortgage-amortization-schedule-TC001056620.aspx One thing that it is ...
3
votes
4answers
1k views

Mass Convert .xls and .xlsx to .txt (Tab Delimited) on a Mac

I have about 150 .xls and .xlsx files that I need converting into tab-delimited. I tried using automator, but I was only able to do it one-by-one. It's definitely faster than opening up each one ...
0
votes
0answers
24 views

How can I make sure MS Office closes all its file handles?

When I'm working on a bunch of different files--and I notice this most especially with Excel and Outlook--that when I close out a window for a particular file, and I go to rename it or delete it ...
-1
votes
3answers
150 views

Microsoft Excel. Inserting a common thing to entire row/column

I'm encountering a basic problem with excel and outlook. Please give it a thought. I have a list of phone numbers on excel sheet as well as outlook. It's just one column. All I need to do is insert ...
0
votes
1answer
240 views

Find broken links to other documents in MS-Office documents (Word)

In our team we have a shared folder with all the documents. Most documents contain hyperlinks to other documents. From time to time, we move some files and links get broken. I need a tool that ...
0
votes
2answers
266 views

Increment a cell value every 23rd line

I have the statement below at every 23rd line in an excel sheet CSV format (there are no formulae in the document, I just assumed using excel would be the easiest way to change this!) ...
0
votes
0answers
16 views

Finding Date Created in Office 2007-

I use Office 2007 I cannot find the date a document was created, as in the older versions of Office. I have tried exactly what MS says to do and there are no advanced settings under the 'prepare' ...
0
votes
0answers
37 views

Secondary labels for y-axis values

I have the following request. The client wants me to create a sort of Gantt graphic with Excel, and wants me to have dates in the y-axis in a bar chart. It also wants me to include under those date ...
1
vote
2answers
1k views

MS Excel: Can I link images using a relative path?

I am working on an MS Excel document that contains a lot of (around 200) images. They are currently saved within the document, so the file becomes huge and working gets very slow. Linking the ...
2
votes
2answers
860 views

How to disable keyboard shortcut animation in Office 2013?

I am looking for a way to disable the animations for keyboard shortcut selection in Office 2013, especially Excel 2013. When you select a keyboard shortcut using Alt and a key sequence (e.g. ...