1
vote
1answer
292 views

Why has Excel stopped offering to sort adjacent Columns?

Xp3. Excel 2003 (11.8346.8341) Sp3 In the past, whenever I selected a columns that was next to another column and selected "sort", Excel would offer to sort the adjacent columns well. This was very ...
0
votes
4answers
119 views

How to resolve #NAME? error in Excel?

I'm use Excel 2003. There is numeric information in Cell AI in my Spreadsheet. The cell is formatted as numeric with 4 decimal places. In Cell AK, which is also formatted as numeric, I type =AI and ...
1
vote
2answers
1k views

Excel 2003 opening files on network

The network is laid out with an XP Pro computer as the server hosting files, then 3 XP computers connecting to it for filesharing, all on it's own router. One computer can open .xls files no problem, ...
0
votes
1answer
735 views

Excel file with macros saved in 2007 crashes when opened in 2003

My team keeps a large Excel file on a SharePoint server. Recently I've edited this file with Excel 2007 and saved it. Afterwards, everyone who opened the file with Excel 2003 and chose to "Enable ...
3
votes
3answers
4k views

How do I exit Excel full screen after switching desktops using MSVDM

When I switch desktops with MSVDM (Microsoft Virtual Desktop Manager) Excel goes into some kind of full screen mode, where no tool bars or menus are visible in the Excel window. Then I can not find ...
0
votes
1answer
190 views

Moved files only opening as 'read-only' in Excel

I moved a large directory of Excel files to another machine. When I sign in as myself (administrator signing into domain) then the files open just fine, but when I sign in as a Power User directly ...
1
vote
4answers
1k views

calculate time differences in excel 2003

I have a goal of 2h47m00s minutes per month. If I attend let's say 1h20m00s and when my Excel cell format is: [Red]-[m]:ss;[Blue][m]:ss ...then it gives me in red color 87 minutes time difference ...