Linked Workbooks return #VALUE error until linked workbooks are opened
I used to save linked workbooks onto a remote server. One could be opened and it would display the last values it had. Now, the linked formulas show #VALUE error until the linked sources are opened. I’d really like to be able to open just one workbook at a time. Is there some setting in [...]
Answer Question
| February 7, 2010 3:39 PM
Excel 2003, Excel 2007, Microsoft Excel
I used to save linked workbooks onto a remote server. One could be opened and it would display the last values it had. Now, the linked formulas show #VALUE error until the linked sources are opened. I’d really like to be able to open just one workbook at a time. Is there some setting in [...]
Answer Question
| February 7, 2010 3:39 PM
Excel 2003, Excel 2007, Microsoft Excel
Deleting all formulas in a worksheet when unprotected in VBA code
I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have protected using the [...]
Answer Question
| September 26, 2008 9:52 AM
Excel 2003, Excel formulas, Microsoft Excel, VBA, Visual Basic for Applications
I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have protected using the [...]
Answer Question
| September 26, 2008 9:52 AM
Excel 2003, Excel formulas, Microsoft Excel, VBA, Visual Basic for Applications
Script to extract files information from ftp server
Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it’s easiest) which when run, it will: 1. Log on to a ftp server using a generic account and password 2. It then find the files (no downloading) in a specific folder that [...]
Answer Question
| September 24, 2008 9:33 PM
CSV, FTP, FTP Server, Microsoft Excel, Scripts
Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it’s easiest) which when run, it will: 1. Log on to a ftp server using a generic account and password 2. It then find the files (no downloading) in a specific folder that [...]
Answer Question
| September 24, 2008 9:33 PM
CSV, FTP, FTP Server, Microsoft Excel, Scripts
excel macro formated to highlight current date
I have a calendar in an excel workbook that I would like to develop a macro that could be formated to highligt the current date. I have my dates formated as the serial date. When I write my macro it highlights the same “number” “=DAY(TODAY())” in every month.
Answer Question
| September 26, 2008 5:19 PM
Excel 2003, Excel macros, Microsoft Excel
I have a calendar in an excel workbook that I would like to develop a macro that could be formated to highligt the current date. I have my dates formated as the serial date. When I write my macro it highlights the same “number” “=DAY(TODAY())” in every month.
Answer Question
| September 26, 2008 5:19 PM
Excel 2003, Excel macros, Microsoft Excel
External references in excel gives error while mailing
I had an excel file having external reference. When I email this file to someone else, it shows #REF! in the columns having external reference
Answer Question
| September 23, 2008 4:33 AM
#REF!, External references, Microsoft Excel
I had an excel file having external reference. When I email this file to someone else, it shows #REF! in the columns having external reference
Answer Question
| September 23, 2008 4:33 AM
#REF!, External references, Microsoft Excel
Script to extract files information from ftp server
Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it’s easiest) which when run, it will log on to a ftp server using a generic account and password, then list the files in a specific folder that begins with the string “abc”. [...]
Answer Question
| March 19, 2009 9:34 PM
CSV, FTP, FTP Server, Microsoft Excel, Scripts
Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it’s easiest) which when run, it will log on to a ftp server using a generic account and password, then list the files in a specific folder that begins with the string “abc”. [...]
Answer Question
| March 19, 2009 9:34 PM
CSV, FTP, FTP Server, Microsoft Excel, Scripts
Macro determining end effective dates
I am using Excel 2003. I am creating a data-entry spreadsheet that contains supplier costs for components. For each component (Record), it has a begin date for when the price goes into effect and an end date. Since I want a history of this item and the dates that it increased or changed, there will [...]
Answer Question
| September 23, 2008 8:50 PM
Excel 2003, Excel macros, Microsoft Excel
I am using Excel 2003. I am creating a data-entry spreadsheet that contains supplier costs for components. For each component (Record), it has a begin date for when the price goes into effect and an end date. Since I want a history of this item and the dates that it increased or changed, there will [...]
Answer Question
| September 23, 2008 8:50 PM
Excel 2003, Excel macros, Microsoft Excel
Add in option to transfer from Iseries to excel2007
I cannot find where to add in the Iseries transfer from or to the Iseries in Excel 2007 running windows vista.
Answer Question
| November 20, 2009 7:26 PM
Excel 2007, iSeries, Microsoft Excel, Vista
I cannot find where to add in the Iseries transfer from or to the Iseries in Excel 2007 running windows vista.
Answer Question
| November 20, 2009 7:26 PM
Excel 2007, iSeries, Microsoft Excel, Vista
Designing a report in SQL from an Excel worksheet
I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to [...]
Answer Question
| September 23, 2008 3:20 PM
Microsoft Excel, SQL, SQL Server reporting
I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to [...]
Answer Question
| September 23, 2008 3:20 PM
Microsoft Excel, SQL, SQL Server reporting
Convert Number value in text string
I am using Microsoft Excel 2007.I want automatic conversion of a number value into relative text string.It means if I have “687″ into one cell, then it should be converted into “Six hundred and eighty seven” into next cell.Pl. guide me for this.
Answer Question
| September 22, 2008 3:52 PM
Excel 2007, Microsoft Excel, Office 2007
I am using Microsoft Excel 2007.I want automatic conversion of a number value into relative text string.It means if I have “687″ into one cell, then it should be converted into “Six hundred and eighty seven” into next cell.Pl. guide me for this.
Answer Question
| September 22, 2008 3:52 PM
Excel 2007, Microsoft Excel, Office 2007
networking
i have pc and thin clients in our bank how can i access to excel and word files on pc through thin client ?
Answer Question
| September 28, 2008 12:58 PM
Microsoft Excel, Microsoft Office, Microsoft Word, Thin clients
i have pc and thin clients in our bank how can i access to excel and word files on pc through thin client ?
Answer Question
| September 28, 2008 12:58 PM
Microsoft Excel, Microsoft Office, Microsoft Word, Thin clients
finding words within other words with an Excel macro
column B has 2 letter words, the next 3 then 4 and so forth. I am looking to find the words in each column to the right to find all of theentrie that contain it and change the color of only the 2 or 3 or 4… letters in the new word for all words [...]
Answer Question
| September 20, 2008 5:59 PM
Excel 2007, Excel macros, Microsoft Excel
column B has 2 letter words, the next 3 then 4 and so forth. I am looking to find the words in each column to the right to find all of theentrie that contain it and change the color of only the 2 or 3 or 4… letters in the new word for all words [...]
Answer Question
| September 20, 2008 5:59 PM
Excel 2007, Excel macros, Microsoft Excel
Auto Sort in Excel
I have the worksheet to Sort in decending order on column L when the workbook is opened. I have a title in Row One, and Header in Row 2, The header in row 2 has autofilter turned on
Answer Question
| September 21, 2008 5:34 PM
Microsoft Excel
I have the worksheet to Sort in decending order on column L when the workbook is opened. I have a title in Row One, and Header in Row 2, The header in row 2 has autofilter turned on
Answer Question
| September 21, 2008 5:34 PM
Microsoft Excel
SQL query ORACLE report “Active Users”
I have problems analysing the standard Oracle report “Active Users”. I want to get my users into excel but the report lay out sucks. How can i get this report directly from the database?
Answer Question
| September 19, 2008 3:25 PM
Microsoft Excel, Oracle database administration, Oracle reporting, Oracle SQL
I have problems analysing the standard Oracle report “Active Users”. I want to get my users into excel but the report lay out sucks. How can i get this report directly from the database?
Answer Question
| September 19, 2008 3:25 PM
Microsoft Excel, Oracle database administration, Oracle reporting, Oracle SQL
Excel macro
I would like the user to be able to hover the mouse over a picture which then would enlarge to some defined size and then return when the mouse is moved off of the object.
Answer Question
| September 18, 2008 11:40 AM
Excel macros, Microsoft Excel
I would like the user to be able to hover the mouse over a picture which then would enlarge to some defined size and then return when the mouse is moved off of the object.
Answer Question
| September 18, 2008 11:40 AM
Excel macros, Microsoft Excel
cell entry that changes
I am a new user to Excel so this is probably a common problem with an easy answer, but I can’t figure it out. When I enter a number (200)in an individual cell and then click on another cell….the number changes (to 220)in the cell I just completed. I try to format the individual “changing” [...]
Answer Question
| September 18, 2008 2:56 PM
Microsoft Excel
I am a new user to Excel so this is probably a common problem with an easy answer, but I can’t figure it out. When I enter a number (200)in an individual cell and then click on another cell….the number changes (to 220)in the cell I just completed. I try to format the individual “changing” [...]
Answer Question
| September 18, 2008 2:56 PM
Microsoft Excel
Perform equation in field during mail merge
I am performing a mail merge in a Word document, using an Excel spreadsheet. Some of the fields represent percentages (format=0.45). I don’t know how to get the resulting merge to show a percentage as 45% without replacing data in the % columns in excel. Is there a way to take the merge field and [...]
Answer Question
| September 16, 2008 10:05 PM
Mail merge, Microsoft Excel, Microsoft Word
I am performing a mail merge in a Word document, using an Excel spreadsheet. Some of the fields represent percentages (format=0.45). I don’t know how to get the resulting merge to show a percentage as 45% without replacing data in the % columns in excel. Is there a way to take the merge field and [...]
Answer Question
| September 16, 2008 10:05 PM
Mail merge, Microsoft Excel, Microsoft Word
Excel – Automatically Publish graphs to Intranet
I want to publish updated graphs to my intranet automaticlly. ie open excel, refresh data (from as400)then save,publish&close (running from the scheduler ) I have my Downloaded vb express & looked at vb sites etc… & managed to create a project which publishes the page to the intranet correctly using f5 but as I say [...]
Answer Question
| September 20, 2008 2:50 PM
Microsoft Excel, VB
I want to publish updated graphs to my intranet automaticlly. ie open excel, refresh data (from as400)then save,publish&close (running from the scheduler ) I have my Downloaded vb express & looked at vb sites etc… & managed to create a project which publishes the page to the intranet correctly using f5 but as I say [...]
Answer Question
| September 20, 2008 2:50 PM
Microsoft Excel, VB
Excel Function Help
I am designing a spreadsheet to keep track of various data. I have a list of birthdays (month and day in separate columns) and I would like to pull the person’s name that corresponds to the particular month. I have attempted to us the lookup function for this, but if there is more than one [...]
Answer Question
| September 11, 2008 5:30 PM
Excel functions, Microsoft Excel
I am designing a spreadsheet to keep track of various data. I have a list of birthdays (month and day in separate columns) and I would like to pull the person’s name that corresponds to the particular month. I have attempted to us the lookup function for this, but if there is more than one [...]
Answer Question
| September 11, 2008 5:30 PM
Excel functions, Microsoft Excel
importing an EXCEL tab
while importing an EXCEL tab with the import wizard, ACCESS 2003 changes a text field with only numbers that exceeds the long integer format to scientific notation. Is there a possibility the numbers do appear?
Answer Question
| September 25, 2008 12:09 PM
Microsoft Access, Microsoft Excel
while importing an EXCEL tab with the import wizard, ACCESS 2003 changes a text field with only numbers that exceeds the long integer format to scientific notation. Is there a possibility the numbers do appear?
Answer Question
| September 25, 2008 12:09 PM
Microsoft Access, Microsoft Excel
