I need to link an excel worksheet to a pegasus opera application but I do not have the architecture of the pegasus file how can I find this out?

I have Windows Vista and Office 2003. (Some background info I recently installed a program called Desk PDF to convert a large Word doc to PDF). When I went...

Following on from here......

Hi, I have a login box pop up when my excel doc opens and i need the password to come up as asterix's (Like logging into windows). Is this possible? If it...

In excel sheet, sometimes we want to group column B-C-D into one group and E-F-I into another group. But the result is column B-C-D-E-F-I is merged into one...

I have an imported column of cells with inconsistently aligned data that I need to split between number & company. I can do the find & replace & then trim...

I have a spreadsheet containing 25000 rows of data. For each row, I am trying to calculate a weighted average cost (rate) based upon certain criteria. Here...

Hello! I installed Excel 2003 recently. There are short cuts in tool tips in Excel 2003. How to prevent the short cuts from disappearing from the tool tips...

When I created a pivot table it used to have selections for eg field "A" of 1,2,3,4,5,6,7,8,9 when i clicked on the field selection within the pivot...

Hi I have a column of cells, each populated with entries delimited by semicolon. When I try to use text to columns, delimited by semicolon, only the first...

Have an Excel Sheet which Contains the Following : DEPT Name Employee Name Emp Code Month Period From Period To Place From Place To Journey...

I have a Master Tab Showing (the table has 1000 records) BU_CD CY_CD Cntry_CD Att_1 Att_2 Att_3 ...

How do I keep a particualr value fixed when using fill. e.g. I want to use fill to produce a set of formulas: =A1+K1, =A2+K1, =A3+K1.......... But using...

i have a question. i am trying to find a function or some way to help me interpolate a range of numbers to find a given value. say i have the range of...

I am wanting to retreive data from an inputted list. What i want to do is input a number and have the function give me the next highest and lowest...

I would like to use the scroll button on my mouse with the list drop down that I made in Excel. Is there anyway to do this? Right now you have to use the...

My title bar NO LONGER reflects the name of my Excel worksheet when I rename it, in fact it doesn't even say Book-1 when I open it up. It says: Microsoft...

I have a complex file that was first authored in Office 2003 (suspected some corruption back then), it has been considerably updated in Office 2007 format. I...

I have a worksheet (Excel 2007) with some restricted data (financial). Many users will need to work with this shared document, however I would like to...

I can save files as .xls from a web-based program that I use. When I save the file, I change the type from a .html to a .xls. I can't get the numbers in...