LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
No Name
 
Posts: n/a
Default Re-calculate

Folks:



In my spreadsheet, I have a section in which imported data from a text file
is located. The other section of my spreadsheet (containing the necessary
formulae)
is devoted to running calculations on the newly imported data. It looks like
the calculations do not completely & automatically take place after the
fresh data
from the text file is imported.

So I have to manually copy & paste the formulae throughout the calculation
section once again. At this point I get to my final destination of nice
clean fresh calculations.
I was hoping to solve this problem by hitting the "Refresh Current Page"
button; but looks like this simply loads the file all over again.

* Is there a way to get my spreadsheet to re-run the calculations
immediately after I re-load fresh data ?



Thanks,
John.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
calculate time does not calculate Wanna Learn Excel Discussion (Misc queries) 4 August 19th 08 12:51 AM
Activesheet.Calculate failing to calculate Daniel Bonallack Excel Programming 2 October 11th 06 03:16 AM
How do I calculate in an IF Takia Excel Worksheet Functions 3 August 23rd 06 09:33 PM
Calculate Anant Arde Excel Programming 1 November 30th 05 01:32 AM
Macro that hide or unhide and not calculate or calculate Jonsson Excel Programming 1 August 19th 03 04:22 PM


All times are GMT +1. The time now is 09:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright Đ2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"