| Thread | Last Post | Replies |
|
| Link Row to Column | 17 Apr 2007 23:02 GMT | 1 |
I have a spreadsheet that has multiple tabs. I want to have a row of data be linked to a column on the other tab. For example: A1 linked to A1 B1 linked to A2
|
| Excel '03 problem | 17 Apr 2007 04:32 GMT | 1 |
When I open excel and click a cell, excel locks on the cell and acts like I'm holding the right mouse button down and selecting a range of cells. And I can't find the key or key combination that frees the cursor/pointer. It happens on every excel file I open.. Anyone have any ...
|
| Shortcut for Next/Previous Worksheet | 17 Apr 2007 04:24 GMT | 5 |
I'm trying to find a keyboard shortcut for selecting the next or previous worksheet tab in a workbook. I've looked at the XL Help for keyboard shortcuts and it states that "ctrl + page up/page down" will move to next or previous worksheet. I've tried this key combination on
|
| Min Function that ignores values of Zero | 16 Apr 2007 17:56 GMT | 7 |
How do I write a function that will find the lowest value greater than zero in a range of cells? This data set will never have negative numbers. Thanks,
|
| Excel 2004 Startup Crash | 16 Apr 2007 16:37 GMT | 2 |
Suddenly Excel 2004 (fully updated) crashes on launch on my MacBook Pro (c2d). I can get it to launch successfully by holding down Shift as it starts. I've created a new document, saved it successfully. But launching Excel or opening an Excel document from the Finder
|
| Object not registered error | 16 Apr 2007 15:20 GMT | 2 |
Please help I am new to Macintosh, I am trying to open a excel file done on a PC but when I open it on Mac. I get Object library not registered error and excel quits
|
| Finding the modes in bimodal and multimodal data sets | 16 Apr 2007 14:25 GMT | 3 |
Excel's MODE function incorrectly reports a single mode in bimodal and multimodal data sets. Does anyone know of a way to get Excel to report the modes in bimodal and multimodal data sets? Thanks.
|
| Copy problems | 15 Apr 2007 16:53 GMT | 1 |
I have had some problems with Excel running very slow at startup, sometimes taking 1-2 minutes to load. After removing and reinstalling, the startup times are better. However, I am not able to copy data from a cell and paste it elsewhere in the same file. When I
|
| Firefox & Excel's "Save as web page.." | 15 Apr 2007 05:22 GMT | 5 |
Ever since I discovered that Excel had a "Save as Web Page..." feature, I've used it for a variety of things. It's so convenient to have the code generated automatically, then just FTP it to my site(s). Where I've run into problems is uploading a whole workbook this way
|
| Excel Edit 'F2' button Microsoft vs Mac - Please help! | 14 Apr 2007 23:40 GMT | 2 |
I just switched to Mac from Microsoft. I was able to use the F2 button to edit a cell and with Mac I cannot use this simple key stroke. Can I set the preferences or a 'sticky key' or 'hot key'... or whatever they are called to allow me to Edit a cell with one key
|
| Changing the Excel Cursor - 'Highlighted Cell' Colors | 14 Apr 2007 22:49 GMT | 3 |
I use Excel all the time and recently switched to a Mac. I just purchased an I-Mac for my wife and a MacBook laptop for my use. The 'cursor' (highlighted cell) on my MacBook is very light blue and very hard to see. The cursor color on the I-Mac desktop unit is orange and
|
| start up issue when optimizing font menu performance.. | 12 Apr 2007 17:25 GMT | 2 |
on Mac OS 10.3.9 with Office 2004... when starting up either of the apps Excel, Word, PowerPoint, on the start up screen has: optimizing font menu performances...
|
| Exporting Reporting Services Excel file on a MAC | 11 Apr 2007 23:05 GMT | 11 |
I have a report that I have to render in Excel, I have created the report using Reporting Services. When I try to open the output Excel file, I get the Error message " Application Excel quit unexpectedly' and I am not able to view the Excel file on MAC. Windows works just fine. ...
|
| PC Spreadsheet to Excel Errors? | 11 Apr 2007 21:37 GMT | 3 |
I just received a spreadsheet from a PC, and the instructions told me to instaill the analysis toolpack, analysis toolpack VBA and zCalc Function Library - I couldnt find the last one, and now the spreasheet cannot calculate dates or holidays. What is the solution (it works on
|
| Compile error: Automation error | 11 Apr 2007 12:41 GMT | 3 |
Greetings, I have a very small excel spreadsheet that was created on a PC but many users run on a mac. The error occurs on the following: Sub Show() emails.show
|