External ref empty/not empty

[horsefish01]

Sorry for the bad topic, had no clue what to use.

I have a workbook where it collects data from external sources to A1:A12

A1 is january ans so on, A12 is December.

I'm mailing this workbook every month to someone around the 10th to give them the data from the previous month. But because the month has already started there are data in the current month also...

Is there someway to stop references from updating until a specifik time?

[Aardigspook]

It depends how you're collecting the data - is it being 'pushed' into Excel by another program or is Excel 'pulling' it? If Excel is pulling it and your data contains a date which can be checked by Excel, you may be able to use a simple Month check using something like: IF(MONTH(DateInYourData)=MONTH(TODAY()),"",YourExistingFormula)
If the data doesn't contain an Excel-readable date, adding a helper column (B) might work: IF(MONTH(B8)=MONTH(TODAY()),"",YourExistingFormula)

You'll get better help if you upload a sample file for us to look at (click 'Go Advanced' under the reply box then use the paperclip icon).

If it's only a few cells though, would it not be easier just to copy the data up to the previous month, Paste Values into a new file and e-mail that?

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.