Pages

Search

Excel IT Pro Discussions Forum: Excel 2007 does not prompt user that the file is opened by another user. Thi...

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel 2007 does not prompt user that the file is opened by another user. This is NOT a shared file.
We have had multiple incidents where 2 employees access the same file but neither are prompted that it is in use.  This is NOT a shared file so why does it not prompt?

Excel Help Forum - Excel Charting & Pivots: Switching axises

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Switching axises
I have this chart (see attached) that I want to change the x axis for the y axis and the y axis for the x axis. Attachment 189413 (http://www.excelforum.com/attachment.php?attachmentid=189413)

Excel Help Forum - Excel Programming / VBA / Macros: How to dynamically update links based on data (not Cells) in PowerPoint via E...

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
How to dynamically update links based on data (not Cells) in PowerPoint via Excel?
Ok say I have an Excel sheet that gives me all my data and each section in that Excel sheet is linked (embeded object) to a PPT slide. How do I get the data in the powerpoint slides to update based on data (primary key) rather than cell position? For example (see excel data source table below): If...

Excel Help Forum - Excel General: Organize List of Reps

Feed2Mail notification - new post on Excel Help Forum - Excel General
Organize List of Reps
Good Afternoon, Within Column A exists sales reps names; I.E. bob billy brooke bob

Excel Help Forum - Excel Programming / VBA / Macros: Matrices

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Matrices
Hi, I have a cummulative matrix (based on the help from a previous thread) which I use for deciding the probability of a program switching between values, but I'd like to use a simpler transition matrix as input (as people understand that a bit better). Currently I have a matrix that looks...

Excel Help Forum - Excel General: If Value in Sheet 1 Exists in Another Workbook/Worksheet, Copy/Paste Entire Row

Feed2Mail notification - new post on Excel Help Forum - Excel General
If Value in Sheet 1 Exists in Another Workbook/Worksheet, Copy/Paste Entire Row
I have a sheet named Tracking File and the value that I want to use for reference is contained in Column A, let's call Column A, order_id. The Tracking File workbook only contains the order_id column, but I need to be able to find each of these order_id values in other sheets (or workbooks in...

Excel IT Pro Discussions Forum: 2010 Excel Spreadsheet not saving on the network

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
2010 Excel Spreadsheet not saving on the network
We have about 25 Desktops in the office. We are upgrading them to Office 2010 from Office 2003. We have a group of desktops that work together on an excel spreadsheet. The spreadsheet is located on the server. When 1 computer makes changes and saves it and opens it later on she notices that her pervious save was not saved. Another Desktop is doing the same thing, but not confirmed. Is this a Office 2010 Excel problem, because we had 2003 for years and no issues.