cache

I am wondering if i need to do this and if its possible- My spreadsheet app has about 20 tables referencing 4 caches of data... I read something John Walkenbach wrote that said to minimize the number of caches by copy/pasting pivot tables rather than creating a fresh pivot table. I was...

Hi Experts You may help in this one. I have a workbook that open and copy another workbook (with one sheet). Thiworkbook copied contains 17 columns and an increasing number of cells (right now about 180). It change fortnight and I run a macro that: -copy the workbook -display a report with data...

All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Hoping for confirmation. If I create a Pivot Table in Excel from a file. Does the original Data set need to remain with the new Pivot Table as a separate sheet, or is the data kept in a...

My boss was working on a spreadsheet in Excel 2002 - she accidentally closed the file without saving it (she had a couple of hours worth of work on the sheet). Is there a way to recover the document? Does Excel automatically cache documents to a default directory? if so, where? Any...

[Hi all - my first post so please forgive any noobness] I have a worksheet with an auto_open() sub which opens another workbook via a URL to manipulate some data. Application.Workbooks.Open "http://myUrl/datafile.xls", Password:=myPwd That works OK, but I've found that if the user's PC is...