All Questions
Tagged with microsoft-office-2013 microsoft-excel
17
questions
1
vote
0
answers
55
views
How does Office 2013's document locking work?
I've run into a couple of problems with files being locked/unlocked in Office 2013 in my company.
documents (Word/Excel files, mostly) are getting unlocked if not regularly saved. A user has a server ...
0
votes
0
answers
460
views
Excel 2013 side-by-side sheet view
In Excel 2013, if I want to view different sheets from the same workbook side-by-side I first have to click View->New window otherwise the side-by-side option is greyed out.
After I click both New ...
0
votes
0
answers
920
views
Moving Excel document breaks hyperlinks URL format
Scenario: I am creating an Excel spreadsheet with file locations and using hyperlinks to open either the file or directory it is stored in.
Problem: I noticed when I hyperlinked a file it used ..\..\ ...
5
votes
2
answers
11k
views
How to disable copy-as-image in Excel?
Recently it seems Excel has made copy-as-image default behaviour for the Ctrl+C hotkey (actually it seems to put the formatted text, table cell data, and a print-view image on the clipboard ...
-2
votes
1
answer
126
views
Excel Macro issue
I have a very detailed and formula heavy workbook template that I use daily. I originally created it in Excel 2010.
I have several macro buttons I created that save certain ...
1
vote
0
answers
314
views
Office 2013: Pasting graph from Excel changes decimal separator. Changing the format code turns my axis values into zeroes
I have created charts in Excel 2013 where I have managed to change the decimal separators to points instead of commas (I'm on a Swedish computer). When pasting these charts to Powerpoint (or Word for ...
3
votes
1
answer
3k
views
How do I force Excel to open documents with add-ins when another application has opened Excel process?
When MATLAB R2015b interacts with Excel, it opens one Excel process and then keeps the process open until MATLAB is closed. When this happens, if I try to open a spreadsheet through File Explorer, it ...
0
votes
0
answers
571
views
Inventory list in Excel
I'm posting this as a new question, because the first one I posted wasn't very clear.
I'm making an inventory list in Excel, combined with a giveaway/borrow list. There are 3 spreadsheets containing ...
1
vote
1
answer
2k
views
Excel 2013 - Creating 2-data series chart with column width is dynamic (depend on variable)
Using Office 2013 suite (Excel 2013), how to I create x/y graph, we additional dependencies where X columns widths dependant on additional value?
For example, from values such as:
Height Width
...
1
vote
2
answers
2k
views
Excel Opening as a blank spreadsheet, but with values
When we open an Excel spreadsheet that is populated it will open with all of the cells appearing blank. However, if you click on any of the cells you can see in the formula bar at the top that they ...
-1
votes
1
answer
617
views
Insert Excel chart into Word template [closed]
I want to create a Word template. Is it possible, that template will take information from another Excel file automaticaly? And can it use charts?
User story:
The user should open the template, ...
1
vote
1
answer
15k
views
Is there a way to autofill cells in Excel 2013 with keyboard shortcuts? [duplicate]
So very shortly, I want a shortcut equivalent to dragging the little handle in the right-bottom in a cell-selection portion in Excel 2013 (for Windows).
There is many similar questions on the site, ...
1
vote
0
answers
186
views
MS Excel 2013 Basic Help, While Offline, Not Responding
Until about a week ago I could get basic help in Excel 2013. I could search for something like "text functions" and got links to those pages. Now I get no response at all after pressing enter or the ...
1
vote
0
answers
3k
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
1
answer
418
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..
| | | | |
Obviously ...