I'll update data in the source worksheet, then when I go to the pivot table, right click the refresh icon and most times it doesn't refresh. So, I basically rebuild the pivot table from scratc...
Hi
I using the DTPicker add in/element on a number of my user forms, but and it seems to be a big but.....
DTPicker seems to always require a date?
Example of why this is causing me ...
I have a large database of account costs that I want to present on a summary worksheet.
I've looked at using the DSUM function as I've been told this is better that array formulas.
The p...
I was adding a function to personal.xls yesterday, which I unhid for the purpose, and now I can't hide it again (the option is greyed out).
Any suggestions?
Mike
I have many blocks of data in column G of an excel spreadsheet, each block is separated by an empty cell. Each block may contain a varying number of rows. I want vba code to sum the individu...
Hi Experts,
This is a Time-sensitive question ... trying to save a half-day's work on a Userform that I made a mistake of calling a print routine that ends with a Print Preview ... so the P...
I have an excel application where I use the ODBC inteface to display predefined access (or more specific, jet db engine) tables and queries in excel sheets and pivot tables.
The tables an...
I am looking for a formula to calculate interest rates
Looking for Credit Card Forcasting
Have a set interest rate, a variable balance and a different amount of days between statements
...
I'm pulling external data from sql 2000 to the sheet on file open. How can I supress the "Enable Automatic Refresh" dialog when the xls is opened and default to 'yes'. Is there a local securit...
I have been using Excel to calculate large amounts of data. Would the performance be helped with a dual core processor? In other words, can Excel take advantage of multiple-threading?
Hi there,
I have the following formula in 168 cells (the $B9 can change depending on the cell). It apparently works and returns the data it is supposed to correctly.
=IF(ISERROR(GETPIVO...
Hello,
I have a worksheet that is the result of a crosstab data export from a database. The data is layed out so that the sample name ("Sample") is in column A, the data source ("Source") i...
In my Excel,I have two sheets like this:
A A
1 3 1 5
2 2 2
3 3 2
4 4
5 1 5 2
-------- --...
Hi, I have this macro that formats the data inside cells. Specifically, with the click of the button, if a cell in the zip column (Dig5Col)is found to have a hyphen in it as well as some char...
Hello
This works fine on my PC but when I try to use it on my Laptop it comes back with the era:
Cannot Find "C:\Program"
SAS is installed on the laptop and runs fine.
It's in the same...
I have a custom function to look up the startposition of a search string "#" in the cell formula.
Whilst the custom function work fine when the sign "#" does exit in the formula, it always ...
Hi - I have a question about screen updating. I have short sub-routine (provided below), that goes through anywhere between 40,000 and 50,000 records. The program creates a RegExp that the u...
I have distributed a fairly large and complicated Excel spreadsheet to about 40 users around the company. Most appear to be running trouble free but one user is getting a "Code execution has b...
Hi Excel Experts,
i placed the following code in a WorkSheet:
Private Sub Worksheet_Activate()
Application.OnKey "{F1}", "SearchSheets"
Application.OnKey "{F4}", "CreateNewShee...
Here is the offending code:
ActiveWorkbook.ActiveSheet.Range("A1:IV65000").Select
Application.Selection.Sort Key1:=Range("A2"), Order1:=xlAscending, Key2:=Range("B2") _
, Order2:=x...
From help:
"To remove all manual page breaks on a worksheet, set Cells.PageBreak to xlPageBreakNone."
Are there cases when this doesn't work? I can't seem to get it to run without breakin...
I have set up connection and recordset using ado, and was wondering how I now go about loading the data into a pivot table's source.
Sub HaveRSTNowPivot(rst as adodob.recordset)
with rst...
I'm using solver in excel on a specific column (for instance column C, with all information contain in that column (objective, constraints, variables) (please also note that solver is already ...
My workbook will represent a month. Janurary for example.
Each worksheet will be represented by date. for example worksheet 01-01-05, 01-02-05, 02-03-05 (The format of the date does not matte...
I am trying to export a file into MS Excel 2002 from MS Access 2002. I run the report in Access then click on the Excel link and chose "Analyze with MS Excel" it opens excels but gives the f...
