A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Text shows up at all # symbols by AKMMS
I received an Excel file, and for an unknown reason, the text in just one of the cells displays as all # symbols, even though I can see actual text in the...
June 3rd, 2010 10:56 PM
by Gord Dibben Go to last post
3 394
Automatically update worksheet name by JuneS
Is there a way to change the names of worksheets automatically? I use Excel 2007 for invoicing, but it's really a pain to have to rename each sheet to...
June 3rd, 2010 10:25 PM
by Bob Phillips[_3_] Go to last post
1 365
Macro to sort variable data range fails by Kiwipingu
Hi, Can you please help me identify why this macro is failing with the following error? Runtime error 1004: Sort method of Range class failed Row 7 is the...
June 3rd, 2010 10:16 PM
by Jim Cone[_2_] Go to last post
1 432
Break up a name by Jim
Hello, I ahve a list of names, with middle initials, that I need to break up. For example the names are formatted like the following: Bayer, Daniel E. I...
June 3rd, 2010 09:26 PM
by Jim Go to last post
3 382
How do I create a calculated field on the Total in a pivot table? by ??4Pat
How can I create a calculation from the total of a count of a field on a pivot table? Example: I need to calculate the number of employees for each process...
June 3rd, 2010 09:12 PM
by ??4Pat Go to last post
0 392
File in Exclusive Use by SSi308
I have searched this forum and Excel help and cannot find the answer to my seemingly simple question. How does a user take a file out of exclusive use? We...
June 3rd, 2010 08:59 PM
by SSi308 Go to last post
3 421
file with udf extension by Ruth
Hi I have a file with a udf extension. When I searched the several sites said that it was related to excel, so I opened it with excel. When opened, it is...
June 3rd, 2010 08:54 PM
by Dave Peterson Go to last post
2 516
Msg: "Drawing Objects...protected" won't save by christophercbrewster via OfficeKB.com
I'm using an XLS spreadsheet in Excel 2007, and I can't save it in either the old or new format. the message says "Drawing Objects in one or more sheet(s) in...
June 3rd, 2010 08:54 PM
by christophercbrewster via OfficeKB.com Go to last post
2 544
Excel Add-In and Dual Monitor Causing Read-Only by childofthe1980s
Hello: The client has a dual monitor. And, we have a 3rd-party Excel Add-In that "pushes" data into our accounting system from this excel spreadsheet with a...
June 3rd, 2010 08:49 PM
by Dave Peterson Go to last post
1 352
Text Qualifiers by Wavequation
I imported a tab-delimited text file, with quotation marks as the text qualifiers. Excel removed the marks, and now I need to save the file back as text,...
June 3rd, 2010 08:44 PM
by Dave Peterson Go to last post
1 438
Remove preceding zeroes? by hds
I want to enter a value as .050 x 27.5 in a cell. I can due this by formatting the cell as text, but when I copy to a new cell I get 0.050 x 27.5. Formatting...
June 3rd, 2010 08:23 PM
by Glen (TD DTP) Go to last post
1 340
Sumif and vlookup Help by Nikki
Can you please help me with setting up a formula? Product A = $100 Product A = $100 Product A = $300 I want my result to be Product A = $500 not $100....
June 3rd, 2010 06:54 PM
by John Go to last post
2 405
Deleting cliparts in excel sheet by Karina
I have an excel sheet in wich I paste everyday new information, replacing the previous day information. There's a clipart that has been pasted over and over,...
June 3rd, 2010 06:35 PM
by Don Guillett[_2_] Go to last post
7 405
Does anyone have a copy of a Payroll Chart when paid every 2 week by Dolores Pray [email protected]
nI am in dire need of a payroll sheet suggestion for employees under a 2 week pay period. It must have a lunch hour also. Any suggestions will be so much...
June 3rd, 2010 06:24 PM
by John Go to last post
2 356
Error message: "Too many cell formats" by karmine
How do you correct this ?
June 3rd, 2010 06:13 PM
by Jim Cone[_2_] Go to last post
4 559
"$" command will not work in VISTA by sjwillow
Hello, Does anyone know why the "$" command will not work in formulas when running VISTA? Does anyone have a solution? A simple version of my problem...
June 3rd, 2010 06:05 PM
by sjwillow Go to last post
4 396
Average value only for the filtered area.. by Sasikiran
Dear, I have data in the range of cells A2:E1000. The row 1 has the headers to which i had given filters. The column E has a numeric value for which an...
June 3rd, 2010 05:50 PM
by Don Guillett[_2_] Go to last post
4 442
Where is the Object section? by gudencough
I need to put a sub command into the object section for a formula to work. However i am not understanding what or where the object or object section is. Does...
June 3rd, 2010 05:21 PM
by gudencough Go to last post
4 408
How do I save Pivot Table Data by webeinky
Hello, I have created a Pivot Table in a Excel 2007 Template which uses the data from an Access 2007 table. In my Connection Properties I have all the...
June 3rd, 2010 04:44 PM
by webeinky Go to last post
4 439
My spreadsheet only appears in the top left of the page. by Terry Evans
My spreadsheet only appears in the top left of the page and I am unable to resize it. You can only view rows 1-17. You can scrool down and across. This is...
June 3rd, 2010 04:08 PM
by Dave Peterson Go to last post
1 456
Post New Thread

Display Options
Showing threads 121 to 140 of 139764
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.