Big Help Needed Excel '95
A friend has a simple spreadsheet with 6 tabs along the bottom. Win 95 and Office 95 installed. One of the Tabbed sheets had a HUGE list of items and he "hit some key" and wiped out the data in the sheet. Doesn't know what he did and worse still saved the file and exited. Has no back-up! He can't duplicate what he did or even know what he did. I appreciate the data is probably lost, but my query is that the sheet, when you click the Tab shows no cell lines at all, no data obviously, but no cells at all? There are line numbers down the left side that you can click on but no column letters along the top? What on earth has happened? Nothing is "Hidden" via the menu system. The other tabbed sheets are fine and in fact this sheet has its total sent to a summary sheet (from a cell H1125) and that summary is showing in the other sheet, yet there is no visible cell H1125 or the mass of other data. It is formatted as GENERAL, and that is how it would have been before, as there were names of wine and stock and price in the sheet. This is a struggling friend in a small business and rather than him have to type 30 pages of data back in (he has a print out but not a saved file!) would like some clues as to what has happened. Worse still, as this sheet no longer seems to be a sheet with cells, then he can't even type the data back in here? Deleting the sheet is going to screw the rest of his simple workbook up, which I would prefer not to do. I have tried copying the blank sheet to another workbook and it comes up the same, no cells and blank. Appreciate any assistance Frenchy Yeh, and I have lectured him on backing up the file and NOT saving the workbook after an error of this magnitude and showed him the UNDO button <smile>
invalid460
excel
39879 articles. 
2 followers.
8 Replies
455 Views
Have him send the file, Frenchy. I'm fairly certain we'll get his data back---all in strictest confidence. ******************* ~Anne Troy www.OfficeArticles.com "Frenchy" <invalid@invalid.com> wrote in message news:Yf1Fe.3321$PL5.317169@news.xtra.co.nz... > A friend has a simple spreadsheet with 6 tabs along the bottom. Win 95 and > Office 95 installed. > > One of the Tabbed sheets had a HUGE list of items and he "hit some key" and > wiped out the data in the sheet. Doesn't know what he did and worse still > saved the file and exited. Has no back-up! He can't duplicate what he did > or even know what he did. > > I appreciate the data is probably lost, but my query is that the sheet, when > you click the Tab shows no cell lines at all, no data obviously, but no > cells at all? There are line numbers down the left side that you can click > on but no column letters along the top? > > What on earth has happened? > > Nothing is "Hidden" via the menu system. The other tabbed sheets are fine > and in fact this sheet has its total sent to a summary sheet (from a cell > H1125) and that summary is showing in the other sheet, yet there is no > visible cell H1125 or the mass of other data. > > It is formatted as GENERAL, and that is how it would have been before, as > there were names of wine and stock and price in the sheet. > > This is a struggling friend in a small business and rather than him have to > type 30 pages of data back in (he has a print out but not a saved file!) > would like some clues as to what has happened. > > Worse still, as this sheet no longer seems to be a sheet with cells, then he > can't even type the data back in here? Deleting the sheet is going to screw > the rest of his simple workbook up, which I would prefer not to do. > > I have tried copying the blank sheet to another workbook and it comes up the > same, no cells and blank. > > Appreciate any assistance > > Frenchy > > Yeh, and I have lectured him on backing up the file and NOT saving the > workbook after an error of this magnitude and showed him the UNDO button > <smile> > > >
ng1Maybe he hid the rows/columns??? Ctrl-a (to select all the cells) Format|Row|Unhide and then Format|column|Unhide or maybe he froze panes and just can't scroll up to see the data. Window|Unfreeze Panes Frenchy wrote: > > A friend has a simple spreadsheet with 6 tabs along the bottom. Win 95 and > Office 95 installed. > > One of the Tabbed sheets had a HUGE list of items and he "hit some key" and > wiped out the data in the sheet. Doesn't know what he did and worse still > saved the file and exited. Has no back-up! He can't duplicate what he did > or even know what he did. > > I appreciate the data is probably lost, but my query is that the sheet, when > you click the Tab shows no cell lines at all, no data obviously, but no > cells at all? There are line numbers down the left side that you can click > on but no column letters along the top? > > What on earth has happened? > > Nothing is "Hidden" via the menu system. The other tabbed sheets are fine > and in fact this sheet has its total sent to a summary sheet (from a cell > H1125) and that summary is showing in the other sheet, yet there is no > visible cell H1125 or the mass of other data. > > It is formatted as GENERAL, and that is how it would have been before, as > there were names of wine and stock and price in the sheet. > > This is a struggling friend in a small business and rather than him have to > type 30 pages of data back in (he has a print out but not a saved file!) > would like some clues as to what has happened. > > Worse still, as this sheet no longer seems to be a sheet with cells, then he > can't even type the data back in here? Deleting the sheet is going to screw > the rest of his simple workbook up, which I would prefer not to do. > > I have tried copying the blank sheet to another workbook and it comes up the > same, no cells and blank. > > Appreciate any assistance > > Frenchy > > Yeh, and I have lectured him on backing up the file and NOT saving the > workbook after an error of this magnitude and showed him the UNDO button > <smile> -- Dave Peterson
petersodNope, was first thing I thought. Unhide and Freeze appear with ticks in the drop down menu if such is invoked and these is nothing there. PLUS, there are no cells available for CTRL-A. The sheet is there (as a clickable Tab at the bottom) but nothing visible when you get there. And neither can you select (click) anywhere in the sheet. Got me stumped! Frenchy "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message news:42E4D59A.43D6A05C@verizonXSPAM.net... : Maybe he hid the rows/columns??? : : Ctrl-a (to select all the cells) : Format|Row|Unhide : and then : Format|column|Unhide : : or maybe he froze panes and just can't scroll up to see the data. : Window|Unfreeze Panes : : : Frenchy wrote: : > : > A friend has a simple spreadsheet with 6 tabs along the bottom. Win 95 and : > Office 95 installed. : > : > One of the Tabbed sheets had a HUGE list of items and he "hit some key" and : > wiped out the data in the sheet. Doesn't know what he did and worse still : > saved the file and exited. Has no back-up! He can't duplicate what he did : > or even know what he did. : > : > I appreciate the data is probably lost, but my query is that the sheet, when : > you click the Tab shows no cell lines at all, no data obviously, but no : > cells at all? There are line numbers down the left side that you can click : > on but no column letters along the top? : > : > What on earth has happened? : > : > Nothing is "Hidden" via the menu system. The other tabbed sheets are fine : > and in fact this sheet has its total sent to a summary sheet (from a cell : > H1125) and that summary is showing in the other sheet, yet there is no : > visible cell H1125 or the mass of other data. : > : > It is formatted as GENERAL, and that is how it would have been before, as : > there were names of wine and stock and price in the sheet. : > : > This is a struggling friend in a small business and rather than him have to : > type 30 pages of data back in (he has a print out but not a saved file!) : > would like some clues as to what has happened. : > : > Worse still, as this sheet no longer seems to be a sheet with cells, then he : > can't even type the data back in here? Deleting the sheet is going to screw : > the rest of his simple workbook up, which I would prefer not to do. : > : > I have tried copying the blank sheet to another workbook and it comes up the : > same, no cells and blank. : > : > Appreciate any assistance : > : > Frenchy : > : > Yeh, and I have lectured him on backing up the file and NOT saving the : > workbook after an error of this magnitude and showed him the UNDO button : > <smile> : : -- : : Dave Peterson
Can you post a screen shot somewhere - I'm having trouble picuring what the worksheet looks like. Also, if you think the dat ais there for some reason, try this, insert a new worksheet, go to the mysterious woksheet, select all, copy, then paste into the newly added worksheet.
comish4lifWill post later today (I don't have the file) Have tried to copy the sheet, nothing happens Frenchy <comish4lif@verizon.net> wrote in message news:1122319849.195114.191020@g47g2000cwa.googlegroups.com... : Can you post a screen shot somewhere - I'm having trouble picuring what : the worksheet looks like. : : Also, if you think the dat ais there for some reason, try this, insert : a new worksheet, go to the mysterious woksheet, select all, copy, then : paste into the newly added worksheet. :
If you put a formula like:
=counta('sheet2'!a:iv)
in another worksheet, what answer do you get?
If it's 0, then there's nothing on that sheet.
Frenchy wrote:
>
> Will post later today (I don't have the file)
>
> Have tried to copy the sheet, nothing happens
>
> Frenchy
>
> <comish4lif@verizon.net> wrote in message
> news:1122319849.195114.191020@g47g2000cwa.googlegroups.com...
> : Can you post a screen shot somewhere - I'm having trouble picuring what
> : the worksheet looks like.
> :
> : Also, if you think the dat ais there for some reason, try this, insert
> : a new worksheet, go to the mysterious woksheet, select all, copy, then
> : paste into the newly added worksheet.
> :
--
Dave Peterson
OK, my thanks to Dave and Anne for their prompt and helpful input.
Problem was solved when I brought the file to my computer and was able to
actually see the screen (this file was being managed on a 10 year old
Toshiba with Win 95 and I think a failing screen!)
Seems he had somehow gone beyond the range of the available Columns. He was
at column IV and that was just blank space and no column header letters but
you could see it when you clicked the row number. On my computer (MS Office
2003) I was able to return to Column A and voila, all the data (about 1300
lines, so that was a real long job to re-type)
Your help was much appreciated
Frenchy
"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:42E54BE3.959B4845@verizonXSPAM.net...
: If you put a formula like:
:
: =counta('sheet2'!a:iv)
:
: in another worksheet, what answer do you get?
:
: If it's 0, then there's nothing on that sheet.
:
: Frenchy wrote:
: >
: > Will post later today (I don't have the file)
: >
: > Have tried to copy the sheet, nothing happens
: >
: > Frenchy
: >
: > <comish4lif@verizon.net> wrote in message
: > news:1122319849.195114.191020@g47g2000cwa.googlegroups.com...
: > : Can you post a screen shot somewhere - I'm having trouble picuring
what
: > : the worksheet looks like.
: > :
: > : Also, if you think the dat ais there for some reason, try this, insert
: > : a new worksheet, go to the mysterious woksheet, select all, copy, then
: > : paste into the newly added worksheet.
: > :
:
: --
:
: Dave Peterson
Darn. I was sure hoping for that free bottle of wine. :)
Glad you got it sorted!
*******************
~Anne Troy
www.OfficeArticles.com
"Frenchy" <invalid@invalid.com> wrote in message
news:Q3eFe.3428$PL5.330584@news.xtra.co.nz...
> OK, my thanks to Dave and Anne for their prompt and helpful input.
>
> Problem was solved when I brought the file to my computer and was able to
> actually see the screen (this file was being managed on a 10 year old
> Toshiba with Win 95 and I think a failing screen!)
>
> Seems he had somehow gone beyond the range of the available Columns. He
was
> at column IV and that was just blank space and no column header letters
but
> you could see it when you clicked the row number. On my computer (MS
Office
> 2003) I was able to return to Column A and voila, all the data (about 1300
> lines, so that was a real long job to re-type)
>
> Your help was much appreciated
>
> Frenchy
>
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:42E54BE3.959B4845@verizonXSPAM.net...
> : If you put a formula like:
> :
> : =counta('sheet2'!a:iv)
> :
> : in another worksheet, what answer do you get?
> :
> : If it's 0, then there's nothing on that sheet.
> :
> : Frenchy wrote:
> : >
> : > Will post later today (I don't have the file)
> : >
> : > Have tried to copy the sheet, nothing happens
> : >
> : > Frenchy
> : >
> : > <comish4lif@verizon.net> wrote in message
> : > news:1122319849.195114.191020@g47g2000cwa.googlegroups.com...
> : > : Can you post a screen shot somewhere - I'm having trouble picuring
> what
> : > : the worksheet looks like.
> : > :
> : > : Also, if you think the dat ais there for some reason, try this,
insert
> : > : a new worksheet, go to the mysterious woksheet, select all, copy,
then
> : > : paste into the newly added worksheet.
> : > :
> :
> : --
> :
> : Dave Peterson
>
>
Similar Artilces:
SQL in Excel data
Hi all, Is there a possibility/way to run an SQL query in an excel data sheet? I have quite some data like the sample below, now i would like to have the sum of spending for each person. Like it is possible in Access. A1 B1 Field1 Field2 Chuck 12,89 Mike 23,09 Jean 9,34 Chuck 30,00 Mike 3,80 Chuck 22,00 Mike 7,23 Jean 10,55 Jean 10,75 Jean 31,45 Chuck 19,99 Result Field1 SumOfField2 Chuck 84,88 Jean 62,09 Mike 34,12 Advice would be appriciated. Cheers, Ludovic Hi You could use a formula like this ...
Excel 2003 extract repeating cells
I have successfully sorted my data to show repeating entries in relation to two specific columns. I can't seem to figure out how to select these repeating entries (without doing it manually, of course) and putting them either into their own column(s) or an entirely different spreadsheet altogether. The goal is to save time in managing THOUSANDS of documents in this manner so that my colleagues can easily pick up repeating entries and take according action. Doing it manually is very time-inefficient. Nit Wit, You don't really describe enough of your layout or what you actually mean...
Exporting file names to an excel spreadsheet.
I have a folder containing many many many .pdf files. Is there a way to export the filenames of these .pdf files into an excel spreadsheet? If this is a dumb question, I apologize. I didnt have any luck searching for the answer here. -- Kepf ------------------------------------------------------------------------ Kepf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30611 View this thread: http://www.excelforum.com/showthread.php?threadid=547520 I use Jim Cone's fine Add-in called "ListFiles"for this sort of thing. It's available free (a...
Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell corresponding to an input of a min and a max. Here are the details. On one sheet I have a box where you enter th min and a box where you enter the max. In another sheet I want column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho would I do this -- Thundersix ----------------------------------------------------------------------- Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055 View this thread: http://www.excelforum.com/showthread.php?threadid=50207 Name the...
excel spreadsheet
How do I delete columns from my spread sheet? When I right click the word "delete" isn't highlighted, so it doesn't work. Is the sheet protected or shared? -- Regards, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== "Ang" <Ang@discussions.microsoft.com> wrote in message news:418A7E09-1E8E-41E1-9988-82460B633629@microsoft.com... How do I delete columns from my spread sheet? When I right click the word "delete" is...
excel, worksheet, set print area, position selection on printed pa
Office 07, Excel. Print area is set, print preview displays selection, always on far left of page. I want to choose the position on the page, eg centered or right aligned etc. Help please. Hi, To get your printout to center on the page chose Page Layout, click the Page Setup quick launch button (bottom right corner of the Page Setup group). Choose the Margins tab, click Horizontal. There is no command to right align a printout, but you can change the left margin to force the printout to the left. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Eve Al...
Please help..with a formula. I don't know code.
I have a long list of numbers - values in a file X, and I want to fin and replace those values in a even larger list in a file Z an highlight those values in Z -- Message posted from http://www.ExcelForum.com Hi not really sure what you're trying to achieve. What do you want to replace, etc. You may give an example (plain text - no attachment please) >-----Original Message----- >I have a long list of numbers - values in a file X, and I want to find >and replace those values in a even larger list in a file Z and >highlight those values in Z. > > >--- >Message...
Need a default email account for all users, need help.
I have a tablet PC running WinXP Tablet with Outlook 2003. This tablet will connect to our exchange server via VPN. How can I set it up so that everyone that logs onto their account can access one (the same) email account. The problem is that I dont know at this point all of the users however anyone using the tablet will use one generic email account. So how can I set Outlook to default to this account so that no matter who logs on they will use this account? Thanks! Shane ...
URGENT HELP NEEDED! Need to restore email account
A friend of mine has just deleted her primary email account (listed as Microsoft Exchange Server) from her Outlook 2003 (she's running Win 2000) as she has just got a new internet provider but on doing that all her inbox, address book etc has disappeared. She desperately needs to recover it as soon as possible .. can it be done and if so how? Would really appreciate any help as she has urgent messages which need to be sent The mail and contacts would still be on the Exchange Server. She can use = the Tools | E-mail Accounts command to add the Exchange account back to = Outlook.=20 ...
Need help with formula 01-13-10
I am trying to adapt a formula in I2 from another spreadsheet that works well, but won't in mine. I've traced the error, but I would need help to understand the help it gives! My formula is this: =IF(J2="0-Jan-00","To be advised",WORKDAY(J2,1,NWD)). I have a worksheet in the same workbook with a list of non-workdays, and defined the column of dates with the name "NWD". What I expect the formula to do is this: If J2 is Feb. 4, it would give Feb. 5 in cell I2 because Feb. 5 is NOT a non-workday in NWD. But if J2 is Feb. 5, and Feb. 6 and...
how to turn off automatic format in Excel?
Hi Excel automatically change the first character in a cell to be uppercase. I just want lowercase. How can I turn off this function? Thanks Ngoc Hi Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence. Andy. "ngoc" <linh@chello.no> wrote in message news:BOKNb.271$O41.819@amstwist00... > Hi > Excel automatically change the first character in a cell to be > uppercase. I just want lowercase. How can I turn off this function? > Thanks > Ngoc > ...
DEADLINE... PLEASE HELP! Stacked Bar chart?
I'm not even sure how to ask the question so here's what I have... 2003 2004 2005 Actual/Goal Actual/Goal Actual/Goal Me 1009/1061 591/866 658/897 Comp. A 966/1012 633/811 624/808 Comp. B 699/744 450/593 480/607 Comp. C 957/1005 642/821 665/838 I wanto to show a bar for each competitor, for each year, so there will be 4 bars for each year. Each bar showing Actual performance & Performance Goal...
please help with this query
Ost Ocity Dstate Dcity Carrier Price Rank Diff A B C D X 1200 1 100 A B C D Y 1300 2 100 A B C D Z 1350 3 100 A B C D W 1789 4 100 A1 B1 C1 D1 X1 785 1 A1 B1 C1 D1 Y1 789 2 The rank for every carrier is based on the price . If rank1 carrier is not a pariticular carrier(say if it is not X1 or Y1 or Z1), then i want to calculate the difference be...
Office 2010 Buying Question Assistance Needed
I've been looking through the MS Office 2010 web site to try to determine what my new small company would require, but I can't find the information I need. We for sure would need Office Pro Plus, but other than that I'm not sure. We want to run it on our own server. We will initially have 3-5 people using it and perhaps more later on. Would we need to purchase site licensing? Unfortunately, our programmers are MS haters (I'm not) and I can't get any assistance from them on this, but I have power of the pen. I would appreciate any assistance I can get. Th...
Excel 2000 macro security Level
Hi! I am running an ASP.NET application which ideally opens an Exce spreadsheet with a macro included in it. When I try opening spreadsheet without a macro, everything works fine, but with macros, i hangs on the opening command. I tried to go to Excel 2000 and go t Tools->Macros->Security Level->Low but it still hangs when I try t open the macro spreadsheet. All works fine with the spreadsheet no containing macros, so it really is a question of macro security. But put it to low, so I don't understand how it is still not opening!! An help would be greatly appreciated! Thanks and...
z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and bars in an Excel 2007 chart, such as drop lines, high-low lines, up/ down bars, and error bars? I observed that when I add drop lines to an Excel 2007 chart, they appear in front of the underlying data -- in my case, the underlying data is displayed as a plotted area. I want the plotted area to be fully visible with no lines over it. I would like to send the drop lines to the back and keep the plotted area in the front, but there is no option to do this. So, is there a procedure for adjusting the z-order of drop...
Do I need download service ? if I already got trial version office 2008 for mac.
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel as title. <edchai@officeformac.com> wrote: > as title. Well I'm not sure I get it. What download service?? You mean you are buying onoine and they are offering you some sort of "online backup"?? It's up to you, but you can probably live without it if it's a simple matter of redownloading the trial and entering your key in it (don;t know - I have the CD version) Corentin -- --- Office:Mac MVP http://www.cortig.net/wordpress/ --- http://www.mvps.org - http...
Running an Excel Macro from an Access Command Button
Hi , Can anyone help me with this, I am trying to run an excel macro from an access command button. I want the macro to Bold the Headings on a excel spreadsheet. The code runs without any errors but the macro doesnt seem to work, I think I have got the line ExcelApp.ExecuteExcel4Macro "RUN(""PERSONAL.XLS!BoldHead"")" wrong The code: Private Sub cmdRunMac_Click() Dim ExcelApp As Excel.Application Dim ExcelBook As Excel.Workbook Set ExcelApp = Excel.Application ExcelApp.Visible = True Set ExcelBook = ExcelApp.Workbooks.Open("C:\Documents and Settings\...
New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet via a macro, a new named range (for the same range) is created. This does not pose a problem, but after a while, I'll have a huge number of named ranges that will never be used. Why does Excel name the range and how can I stop this? I noticed in the recorded macro, there was a line .Name = "drd_5". I commented this out to see what would happen, but it just renamed the range "ExternalData_5". The next one was "ExternalData_6", etc. Thanks, Carroll Rinehart You could refresh with differen...
Formatting Cells in Excel 97
Hi Guys, Sorry if I sound real stupid but is there anyway that we can control the column formatting in Excel 97 like let's say column A = GENERAL(6), column B = GENERAL(4), column C = TEXT(18) etc? Appreciate any form of advice, thanks!! I replied in the programming group. Are you seeking a programming answer? It's usually best to only post to one group, and include the remark "Please tell me if I should ask this in another group." On Thu, 28 Aug 2003 00:56:47 -0700, "Daryl" <daryl.ho@tnt.com> wrote: >Hi Guys, > >Sorry if I sound real stupid b...
Backup Excel file
I want to take backup of a file every time. I am using - save as - tools - general option - always create back up. The backup file is in the same location but I want to put it in a different folder. What should I do, kindly suggest. Thanks Jan Karel Pieterse's has an addin called AutoSafe (note spelling). http://www.jkp-ads.com/Download.htm (look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.) It doesn't overwrite the existing workbook when it saves. It saves to a user selectable folder. And when it's done, it either deletes these backups (or puts them...
Excel devides every number by 100
Even when I open a brand new file. I input a number (ie 5) and get 0.05 back. I have tried doing everything in cell format etc.. anyone have an idea? it is very annoying and adding loads of work to my project. thanks "=?Utf-8?B?a2luZ3M=?=" <kings@discussions.microsoft.com> wrote in news:48A39EFC-2D09-420F-B2DF-6EF5C0DB6109@microsoft.com: > Even when I open a brand new file. I input a number (ie 5) > and get 0.05 back. I have tried doing everything in cell > format etc.. anyone have an idea? it is very annoying and > adding loads of work to my project. > ...
Secure Area Needs Password
Hi, I have Outlook installed. When i start it up a popup box comes up and asks for my windows password. I type this in and it says it is wrong?? i have no passwords on folders, calendars etc.... Any ideas? ...
Excel Histogram -- Incorrect Bins
I am using the Histogram tool in Excel 2004 for Mac -- I am finding that = Excel is shifting all my data one bin to the right. =20 For example, with data... 2,2,2,7,7,7 and bin range selected as 0,5,10 I am EXPECTING 3 items in bin 0 (between zero and five) and 3 items in = bin=20 5 (between five and ten). Excel is RETURNING a histogram with nothing in the zero bin, and 3 items = each in the 5 bin and the 10 bin. This is driving my bonkers! I can't find a solution...can somebody = please=20 help? Eric Anderson - > I am using the Histogram tool in Excel 2004 for Mac -- I am...
Hyperlink File Help
I am needing some major help. I have a file with hyperlinks in column F that link to a file on our server. I am needing to test to see if the file exists and if it does, copy the file to a folder in my documents called (CapturedFiles) and if it doesn't format the cell color to red. Can VBA do this and if so how? Any help would be greatly appreciated. Thanks in advance. Fileserver or webserver ? Tim On Nov 23, 7:20=A0am, Aaron <Aa...@discussions.microsoft.com> wrote: > I am needing some major help. =A0I have a file with hyperlinks in column = F that > l...
Hi all, Is there a possibility/way to run an SQL query in an excel data sheet? I have quite some data like the sample below, now i would like to have the sum of spending for each person. Like it is possible in Access. A1 B1 Field1 Field2 Chuck 12,89 Mike 23,09 Jean 9,34 Chuck 30,00 Mike 3,80 Chuck 22,00 Mike 7,23 Jean 10,55 Jean 10,75 Jean 31,45 Chuck 19,99 Result Field1 SumOfField2 Chuck 84,88 Jean 62,09 Mike 34,12 Advice would be appriciated. Cheers, Ludovic Hi You could use a formula like this ...
Excel 2003 extract repeating cells
I have successfully sorted my data to show repeating entries in relation to two specific columns. I can't seem to figure out how to select these repeating entries (without doing it manually, of course) and putting them either into their own column(s) or an entirely different spreadsheet altogether. The goal is to save time in managing THOUSANDS of documents in this manner so that my colleagues can easily pick up repeating entries and take according action. Doing it manually is very time-inefficient. Nit Wit, You don't really describe enough of your layout or what you actually mean...
Exporting file names to an excel spreadsheet.
I have a folder containing many many many .pdf files. Is there a way to export the filenames of these .pdf files into an excel spreadsheet? If this is a dumb question, I apologize. I didnt have any luck searching for the answer here. -- Kepf ------------------------------------------------------------------------ Kepf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30611 View this thread: http://www.excelforum.com/showthread.php?threadid=547520 I use Jim Cone's fine Add-in called "ListFiles"for this sort of thing. It's available free (a...
Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell corresponding to an input of a min and a max. Here are the details. On one sheet I have a box where you enter th min and a box where you enter the max. In another sheet I want column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho would I do this -- Thundersix ----------------------------------------------------------------------- Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055 View this thread: http://www.excelforum.com/showthread.php?threadid=50207 Name the...
excel spreadsheet
How do I delete columns from my spread sheet? When I right click the word "delete" isn't highlighted, so it doesn't work. Is the sheet protected or shared? -- Regards, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== "Ang" <Ang@discussions.microsoft.com> wrote in message news:418A7E09-1E8E-41E1-9988-82460B633629@microsoft.com... How do I delete columns from my spread sheet? When I right click the word "delete" is...
excel, worksheet, set print area, position selection on printed pa
Office 07, Excel. Print area is set, print preview displays selection, always on far left of page. I want to choose the position on the page, eg centered or right aligned etc. Help please. Hi, To get your printout to center on the page chose Page Layout, click the Page Setup quick launch button (bottom right corner of the Page Setup group). Choose the Margins tab, click Horizontal. There is no command to right align a printout, but you can change the left margin to force the printout to the left. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Eve Al...
Please help..with a formula. I don't know code.
I have a long list of numbers - values in a file X, and I want to fin and replace those values in a even larger list in a file Z an highlight those values in Z -- Message posted from http://www.ExcelForum.com Hi not really sure what you're trying to achieve. What do you want to replace, etc. You may give an example (plain text - no attachment please) >-----Original Message----- >I have a long list of numbers - values in a file X, and I want to find >and replace those values in a even larger list in a file Z and >highlight those values in Z. > > >--- >Message...
Need a default email account for all users, need help.
I have a tablet PC running WinXP Tablet with Outlook 2003. This tablet will connect to our exchange server via VPN. How can I set it up so that everyone that logs onto their account can access one (the same) email account. The problem is that I dont know at this point all of the users however anyone using the tablet will use one generic email account. So how can I set Outlook to default to this account so that no matter who logs on they will use this account? Thanks! Shane ...
URGENT HELP NEEDED! Need to restore email account
A friend of mine has just deleted her primary email account (listed as Microsoft Exchange Server) from her Outlook 2003 (she's running Win 2000) as she has just got a new internet provider but on doing that all her inbox, address book etc has disappeared. She desperately needs to recover it as soon as possible .. can it be done and if so how? Would really appreciate any help as she has urgent messages which need to be sent The mail and contacts would still be on the Exchange Server. She can use = the Tools | E-mail Accounts command to add the Exchange account back to = Outlook.=20 ...
Need help with formula 01-13-10
I am trying to adapt a formula in I2 from another spreadsheet that works well, but won't in mine. I've traced the error, but I would need help to understand the help it gives! My formula is this: =IF(J2="0-Jan-00","To be advised",WORKDAY(J2,1,NWD)). I have a worksheet in the same workbook with a list of non-workdays, and defined the column of dates with the name "NWD". What I expect the formula to do is this: If J2 is Feb. 4, it would give Feb. 5 in cell I2 because Feb. 5 is NOT a non-workday in NWD. But if J2 is Feb. 5, and Feb. 6 and...
how to turn off automatic format in Excel?
Hi Excel automatically change the first character in a cell to be uppercase. I just want lowercase. How can I turn off this function? Thanks Ngoc Hi Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence. Andy. "ngoc" <linh@chello.no> wrote in message news:BOKNb.271$O41.819@amstwist00... > Hi > Excel automatically change the first character in a cell to be > uppercase. I just want lowercase. How can I turn off this function? > Thanks > Ngoc > ...
DEADLINE... PLEASE HELP! Stacked Bar chart?
I'm not even sure how to ask the question so here's what I have... 2003 2004 2005 Actual/Goal Actual/Goal Actual/Goal Me 1009/1061 591/866 658/897 Comp. A 966/1012 633/811 624/808 Comp. B 699/744 450/593 480/607 Comp. C 957/1005 642/821 665/838 I wanto to show a bar for each competitor, for each year, so there will be 4 bars for each year. Each bar showing Actual performance & Performance Goal...
please help with this query
Ost Ocity Dstate Dcity Carrier Price Rank Diff A B C D X 1200 1 100 A B C D Y 1300 2 100 A B C D Z 1350 3 100 A B C D W 1789 4 100 A1 B1 C1 D1 X1 785 1 A1 B1 C1 D1 Y1 789 2 The rank for every carrier is based on the price . If rank1 carrier is not a pariticular carrier(say if it is not X1 or Y1 or Z1), then i want to calculate the difference be...
Office 2010 Buying Question Assistance Needed
I've been looking through the MS Office 2010 web site to try to determine what my new small company would require, but I can't find the information I need. We for sure would need Office Pro Plus, but other than that I'm not sure. We want to run it on our own server. We will initially have 3-5 people using it and perhaps more later on. Would we need to purchase site licensing? Unfortunately, our programmers are MS haters (I'm not) and I can't get any assistance from them on this, but I have power of the pen. I would appreciate any assistance I can get. Th...
Excel 2000 macro security Level
Hi! I am running an ASP.NET application which ideally opens an Exce spreadsheet with a macro included in it. When I try opening spreadsheet without a macro, everything works fine, but with macros, i hangs on the opening command. I tried to go to Excel 2000 and go t Tools->Macros->Security Level->Low but it still hangs when I try t open the macro spreadsheet. All works fine with the spreadsheet no containing macros, so it really is a question of macro security. But put it to low, so I don't understand how it is still not opening!! An help would be greatly appreciated! Thanks and...
z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and bars in an Excel 2007 chart, such as drop lines, high-low lines, up/ down bars, and error bars? I observed that when I add drop lines to an Excel 2007 chart, they appear in front of the underlying data -- in my case, the underlying data is displayed as a plotted area. I want the plotted area to be fully visible with no lines over it. I would like to send the drop lines to the back and keep the plotted area in the front, but there is no option to do this. So, is there a procedure for adjusting the z-order of drop...
Do I need download service ? if I already got trial version office 2008 for mac.
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel as title. <edchai@officeformac.com> wrote: > as title. Well I'm not sure I get it. What download service?? You mean you are buying onoine and they are offering you some sort of "online backup"?? It's up to you, but you can probably live without it if it's a simple matter of redownloading the trial and entering your key in it (don;t know - I have the CD version) Corentin -- --- Office:Mac MVP http://www.cortig.net/wordpress/ --- http://www.mvps.org - http...
Running an Excel Macro from an Access Command Button
Hi , Can anyone help me with this, I am trying to run an excel macro from an access command button. I want the macro to Bold the Headings on a excel spreadsheet. The code runs without any errors but the macro doesnt seem to work, I think I have got the line ExcelApp.ExecuteExcel4Macro "RUN(""PERSONAL.XLS!BoldHead"")" wrong The code: Private Sub cmdRunMac_Click() Dim ExcelApp As Excel.Application Dim ExcelBook As Excel.Workbook Set ExcelApp = Excel.Application ExcelApp.Visible = True Set ExcelBook = ExcelApp.Workbooks.Open("C:\Documents and Settings\...
New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet via a macro, a new named range (for the same range) is created. This does not pose a problem, but after a while, I'll have a huge number of named ranges that will never be used. Why does Excel name the range and how can I stop this? I noticed in the recorded macro, there was a line .Name = "drd_5". I commented this out to see what would happen, but it just renamed the range "ExternalData_5". The next one was "ExternalData_6", etc. Thanks, Carroll Rinehart You could refresh with differen...
Formatting Cells in Excel 97
Hi Guys, Sorry if I sound real stupid but is there anyway that we can control the column formatting in Excel 97 like let's say column A = GENERAL(6), column B = GENERAL(4), column C = TEXT(18) etc? Appreciate any form of advice, thanks!! I replied in the programming group. Are you seeking a programming answer? It's usually best to only post to one group, and include the remark "Please tell me if I should ask this in another group." On Thu, 28 Aug 2003 00:56:47 -0700, "Daryl" <daryl.ho@tnt.com> wrote: >Hi Guys, > >Sorry if I sound real stupid b...
Backup Excel file
I want to take backup of a file every time. I am using - save as - tools - general option - always create back up. The backup file is in the same location but I want to put it in a different folder. What should I do, kindly suggest. Thanks Jan Karel Pieterse's has an addin called AutoSafe (note spelling). http://www.jkp-ads.com/Download.htm (look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.) It doesn't overwrite the existing workbook when it saves. It saves to a user selectable folder. And when it's done, it either deletes these backups (or puts them...
Excel devides every number by 100
Even when I open a brand new file. I input a number (ie 5) and get 0.05 back. I have tried doing everything in cell format etc.. anyone have an idea? it is very annoying and adding loads of work to my project. thanks "=?Utf-8?B?a2luZ3M=?=" <kings@discussions.microsoft.com> wrote in news:48A39EFC-2D09-420F-B2DF-6EF5C0DB6109@microsoft.com: > Even when I open a brand new file. I input a number (ie 5) > and get 0.05 back. I have tried doing everything in cell > format etc.. anyone have an idea? it is very annoying and > adding loads of work to my project. > ...
Secure Area Needs Password
Hi, I have Outlook installed. When i start it up a popup box comes up and asks for my windows password. I type this in and it says it is wrong?? i have no passwords on folders, calendars etc.... Any ideas? ...
Excel Histogram -- Incorrect Bins
I am using the Histogram tool in Excel 2004 for Mac -- I am finding that = Excel is shifting all my data one bin to the right. =20 For example, with data... 2,2,2,7,7,7 and bin range selected as 0,5,10 I am EXPECTING 3 items in bin 0 (between zero and five) and 3 items in = bin=20 5 (between five and ten). Excel is RETURNING a histogram with nothing in the zero bin, and 3 items = each in the 5 bin and the 10 bin. This is driving my bonkers! I can't find a solution...can somebody = please=20 help? Eric Anderson - > I am using the Histogram tool in Excel 2004 for Mac -- I am...
Hyperlink File Help
I am needing some major help. I have a file with hyperlinks in column F that link to a file on our server. I am needing to test to see if the file exists and if it does, copy the file to a folder in my documents called (CapturedFiles) and if it doesn't format the cell color to red. Can VBA do this and if so how? Any help would be greatly appreciated. Thanks in advance. Fileserver or webserver ? Tim On Nov 23, 7:20=A0am, Aaron <Aa...@discussions.microsoft.com> wrote: > I am needing some major help. =A0I have a file with hyperlinks in column = F that > l...