Search results for query: *

gvf/combo: Unfortunately there is only one sheet with formulas on it, D2 -- see post of 29 Dec 08 14:14 for more complete description of workbook. I managed to use code to get all the data/formulas in the worksheets. I'm pursuing the approach of using OpenOffice which I don't have but may...

Thanks Greg: All worksheets are of type -4167 so it doesn't seem that macro worksheets are involved. I may have to try to crack the password locking the sheets that are protected. I tried deleting enough rows so that I could put the worksheet on the site but I can't with the worksheet...

DaveInIowa: All of the worksheets are protected. We did find out that only sheet D2 had formulas on it but using code. See post of 12/29/08 above for details.

DaveInIowa/Combo: The legal department has contacted the employee. When the cell is placed in a cell on the CData worksheet nothing appears in the formula bar -- even though text is showing in the cell. However, going to the VB Editor and typing ?ActiveCell.value or ?ActiveCell.formula...

Thanks combo: The recalculation status set to manual the data dissappears and reappears on CData depending on whether the system date is after or before 4/1/2008 when the calculate (F9) key is pressed. Checking the cells where the data dissappeared however fails to show any conditional...

The problem at this point is that I can't figure out how the data is being erased. It's true that the original problem has been solved -- initially by the observation that by setting the system clock back to 2007 the date weren't erased. What I don't see is how a workbook with no code in it...

Combo/PHV: The workbook can be opened up with the calculation set to Manual and the data are not erased as you indicated. As for the formatting - it gets curiouser and curiouser. In the workbook all worksheets are protected and only CData is visible. I can place a cursor in a cell in CData...

The formulas are on the D2 worksheet but the changes are observed on the CData page which has only raw data - no formulas. Unless something like code is run(and I don't know how it could be without seeing it)I'm not sure how the appearance of change could be made. To do this: The values for...

Combo: You're right there are many ways to hide data without using code but with the exception of the conditional formatting don't they all involve manually changing a property of the workbook or worksheet? What intrigues me about this workbook is that there is apparently no code running, no...

Thanks combo/xlbo: I've recreated the workbook in a new workbook by copying the value & or formula in each cell of the used range using the approach suggested by combo. CData is where the data are stored. D1 appears to be a copy of CData. Each cell in D2 has a formula that returns either the...

Thanks combo/xlbo Your suggestions about viewing the formulas helped. The workbook has 3 worksheets CData (visible), D1 (hidden), D2 (hidden), all are password protected. The used ranges on the three pages are: CData = $A$1:$M$7651 D1 = $A$1:$M$7652 D2 = $A$1:$N$7651 There is only 1 Name in...

Thanks AnotherHiggins for providing a method of getting the data. However, this isn't the main problem at the moment. The data in the workbook consists of 7000+ rows of data that consist of names and addresses. The workbook was being used as a database of useful contacts. As such there were...

Thanks Combo but still no solution. There is no warning macro message. It happens on all machines I have tested. There are no addins running. There is no external data source. I receieved the file from another source and it works whether I am connected to the internet or not. All that the...

At the highest security setting, the data are still erased. A friend provided a clue and by setting the system date back a year the macro doesn't run. Even so, on opening the workbook I was unable to find any macro's present. Apparently, the code erasing the worksheet is hidden elsewhere in...

Searching for sub or function with the setting of current project yields "search text not found" for both. I suspect that the code that erases the data also erases itself.

We have a workbook which when opened, shows the user critical data on a given page and then erases it. Opening the VBA editor in the workbook shows no code in the form of modules nor coded behind the worksheets. There are no forms in the workbook. I have tried to open the workbook using code...

I have created a dll which can be called from a custom Excel workbook. The workbook can successfully use the dll when it is installed on a user's machine. I would like to be able to keep the dll on a network drive that the users could access but keep the custom workbook on the user's...

Are there any good references on how to us MSChart controls on forms. I can construct a chart using the ChartData property but how does this relate to the DataGrid property of MSChart? Also, is there a maximum value for XY graphs? A graph of Y = X^4 dies after X exceeds ~35 (plot from X =...