Switching Excel Custom Views Based on Selection
I have two saved Custom Views for a protected worksheet that I use as an input and summer page for an estimating spreadsheet. I want to include a validated cell on the front page which would select one of these two custom views based on which answer the user selects. Unfortunately I am very...
I have two saved Custom Views for a protected worksheet that I use as an input and summer page for an estimating spreadsheet. I want to include a validated cell on the front page which would select one of these two custom views based on which answer the user selects. Unfortunately I am very...
5 pts.
excel formula
i am working on a worksheet and need totals from a prior worksheet, for one cell i use =sheet2!A3, when i try to get the total from A3 and A4 i do not get the total, i have tried =sheet2!A3+A4, but that does not work, please help
i am working on a worksheet and need totals from a prior worksheet, for one cell i use =sheet2!A3, when i try to get the total from A3 and A4 i do not get the total, i have tried =sheet2!A3+A4, but that does not work, please help
Cannot Open Older Excel Files with 2003
When trying to open older Excel files, i get this message: You are attempting to open a form that is blocked by your registry policy setting. How do I can my registery settings to access older Excel files???
When trying to open older Excel files, i get this message: You are attempting to open a form that is blocked by your registry policy setting. How do I can my registery settings to access older Excel files???
How to link a macro by clicking on a cell of an Excel sheet
I need to get the current time by clicking on the cell in excel.
I need to get the current time by clicking on the cell in excel.
2003 Excel crash
Excel 2003 crashs when opening a Excel 2000 spreadsheet with graphs. Recovery removes the graphs.
Excel 2003 crashs when opening a Excel 2000 spreadsheet with graphs. Recovery removes the graphs.
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 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 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...
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...
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.
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.
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...
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...
MS Office Excel 2007 cannot be open by MS Office Excel 2003 (even after installing compatibility pack)
Cannot open the EXCEL file using MS Office EXCEL 2003 (after installing the Compatibility pack) that was saved by MS Office EXCEL 2007. The error message: This file is not in a recognizable format. If you know the file is from another program which is incompatible with Microsoft Office EXCEL, click...
Cannot open the EXCEL file using MS Office EXCEL 2003 (after installing the Compatibility pack) that was saved by MS Office EXCEL 2007. The error message: This file is not in a recognizable format. If you know the file is from another program which is incompatible with Microsoft Office EXCEL, click...
Export from Access to Excel shifts decimal position randomly
I am exporting from MS Access '03 to MS Excel '03. I retrieve several columns formatted as Fixed width with 2 decimal places in a query and then export those results to Excel. Occasionally, some of the columns, but not all values in that column, will display with the decimal point shifted one...
I am exporting from MS Access '03 to MS Excel '03. I retrieve several columns formatted as Fixed width with 2 decimal places in a query and then export those results to Excel. Occasionally, some of the columns, but not all values in that column, will display with the decimal point shifted one...
Using Excel, I past from a table brom a web site and excel puts everything in one cell
Using Excel 2003, I paste from a table on a web site and excel puts everything in one cell. I have had no problem until today. It seems excel is not recognizing the seporators as it did before. I am using CTR-C and CTR-V to bring the data into my spreadsheet.
Using Excel 2003, I paste from a table on a web site and excel puts everything in one cell. I have had no problem until today. It seems excel is not recognizing the seporators as it did before. I am using CTR-C and CTR-V to bring the data into my spreadsheet.
Can data in Excel 2003 be set up to automatically move from one sheet to another in a workbook?
Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the others we...
Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the others we...
Current Date in Excel Query
I am using Excel 2003. I am trying to run a query that will used daily and the only thing that will change with the query is the current date. Is there a way to use a formula saved in the query that will automatically use the current date instead of having to manually input it everytime? Thank you!
I am using Excel 2003. I am trying to run a query that will used daily and the only thing that will change with the query is the current date. Is there a way to use a formula saved in the query that will automatically use the current date instead of having to manually input it everytime? Thank you!
Statistical functions in C++ MVS/ESA
Miscrosoft Excel has statistical functions such as BETAINV BETADIST NORMDIST NORMINV. Does C++ in MVS/ESA has similar functions? How do you implement statistical functions such as above in a MVS/ESA environment?
Miscrosoft Excel has statistical functions such as BETAINV BETADIST NORMDIST NORMINV. Does C++ in MVS/ESA has similar functions? How do you implement statistical functions such as above in a MVS/ESA environment?
Forms in Excel 2003
I have created a form in 2003 Excel that has drop-down menu from a list file created on multiple worksheet within the document. This works fine. What I need to do is create a drop-down menu on a field that will not only bring up a list of title to choose from but also when a title is selected it...
I have created a form in 2003 Excel that has drop-down menu from a list file created on multiple worksheet within the document. This works fine. What I need to do is create a drop-down menu on a field that will not only bring up a list of title to choose from but also when a title is selected it...
Recording cell value changes to another cell in excel using a macro
Is it possible to use a macro that will record the value changes I make in one cell and make it appear in another cell on the same worksheet? Example: On a worksheet the cell value of A:1 will change every week. As the value is updated, the previous value is copied to another cell on the same...
Is it possible to use a macro that will record the value changes I make in one cell and make it appear in another cell on the same worksheet? Example: On a worksheet the cell value of A:1 will change every week. As the value is updated, the previous value is copied to another cell on the same...
Excel "import external data" Newlines in text query
I am using Excell 2002 "import external data" - With tab delimited fields within record - One text field has newlines within it - The newline is treated as end of record Problem recently arrose possibly coinciding with update to IE version 7 Geof Lewis
I am using Excell 2002 "import external data" - With tab delimited fields within record - One text field has newlines within it - The newline is treated as end of record Problem recently arrose possibly coinciding with update to IE version 7 Geof Lewis
Public Folders
I have created a public folder to store excel spreadsheets that I need users to be able to access and change. I understand the permissions. My question is can more than 1 user be in the same spread sheet at one time and make individual changes.Will all changes be saved?
I have created a public folder to store excel spreadsheets that I need users to be able to access and change. I understand the permissions. My question is can more than 1 user be in the same spread sheet at one time and make individual changes.Will all changes be saved?
Changing Color in a Cell
I am updating a spreadsheet each month which is automated. I have written a macro to update this spread. Each month I append four columns to the end of the spread sheet and update the data in the spreadsheet. The problem that I am having is trying to figure out how to update the heading color for...
I am updating a spreadsheet each month which is automated. I have written a macro to update this spread. Each month I append four columns to the end of the spread sheet and update the data in the spreadsheet. The problem that I am having is trying to figure out how to update the heading color for...
