Menu

Refresh Problems

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

Barry

Barry is offline

external usenet poster

Posts: 1

Default

Refresh Problems

ANYBODY HAVE ANY IDEAS??????????????????

wrote:
I am having some issues with excel clearing out formulas out of column
on its automatic refresh. This is a live data workbook that pulls its
information from our database. I have created a VLOOKUP formula to
adjust the quantities to the correct amounts of assemblies i.e. one
assemble may have 4 subassemblies. I want that column to reflect the
total work not just the main assemblies.1 vs. 4.The formula is
=IF(ISERROR(VLOOKUP(B2,lookuptable!$A$1:$B$25,2,FA LSE)),E2,VLOOKUP(B2,lookuptable!$A$1:$B$25,2,FALSE )*E2).
This formula has been dragged down some 20000 rows and the actual data
only takes up about 4000 rows. After the refreshes blanks start to
appear and they keep growing. The blank cells are random and change
after each refresh.

Any Ideas what this could be caused by?

Thanks,

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problems with .Refresh BackgroundQuery:=False	dmplacebo	Excel Programming	6	July 12th 05 02:00 PM
Problems with .Refresh BackgroundQuery:=False	dmplacebo	Excel Worksheet Functions	0	July 11th 05 12:39 PM
getpivotdata refresh problems	Calgarychris	Excel Worksheet Functions	2	April 5th 05 12:01 AM
Pivot Table Refresh Problems	PFL	Excel Discussion (Misc queries)	2	January 13th 05 01:24 AM
Pivot Table Refresh Problems	[email protected]	Excel Programming	0	January 12th 05 02:41 PM

All times are GMT +1. The time now is 02:38 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement