Tagged Questions
1
vote
1answer
170 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
97 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
597 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 ...
2
votes
3answers
3k 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
153 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 ...
